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.
Deze oefening maakt deel uit van de cursus
Introduction to BigQuery
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Complete the below query
SELECT
-- Add the correct column name
order_id, ___
FROM
ecommerce.ecomm_orders
-- Complete the where statement
WHERE ___ = ___