UNNEST-ing Data
It is more than likely that you will work with nested data such as ARRAYs and STRUCTs. Accessing the data inside those queries will help you create a lot of value from that data and use it to connect to other tables.
Este exercício faz parte do curso
Introduction to BigQuery
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Complete the below query
SELECT
-- Add the correct column name
order_id, ___
FROM
ecommerce.ecomm_orders
-- Complete the where statement
WHERE ___ = ___