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.
Este exercício faz parte do curso
Introduction to BigQuery
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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