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.
Questo esercizio fa parte del corso
Introduction to BigQuery
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Complete the below query
SELECT
-- Add the correct column name
order_id, ___
FROM
ecommerce.ecomm_orders
-- Complete the where statement
WHERE ___ = ___