UNNEST with CROSS JOINs
As you have seen a few other times in the course so far, you can join un-nested values to the values in the original table using the shorthand syntax of a cross join. You can prove this by using the full cross join syntax in this exercise.
Questo esercizio fa parte del corso
Introduction to BigQuery
Istruzioni dell'esercizio
- Finish the query to perform a cross join between the main
ecomm_orderstable and the un-nestedSTRUCTdata contained in the same table in theorder_itemscolumn.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT
o.order_id,
item.price
FROM ecommerce.ecomm_orders o
-- Add the correct join type and syntax to expand the STRUCT data in
___ ___(o.order_items) item