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.
This exercise is part of the course
Introduction to BigQuery
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Complete the below query
SELECT
-- Add the correct column name
order_id, ___
FROM
ecommerce.ecomm_orders
-- Complete the where statement
WHERE ___ = ___