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.

Deze oefening maakt deel uit van de cursus

Introduction to BigQuery

Cursus bekijken

Oefeninstructies

Finish the query to perform a cross join between the main ecomm_orders table and the un-nested STRUCT data contained in the same table in the order_items column.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

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

Code bewerken en uitvoeren