UNNEST-ing Data
It is more than likely that you will work with nested data such as ARRAY
s and STRUCT
s. 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 ejercicio forma parte del curso
Introduction to BigQuery
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
-- Complete the below query
SELECT
-- Add the correct column name
order_id, ___
FROM
ecommerce.ecomm_orders
-- Complete the where statement
WHERE ___ = ___