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.

Cet exercice fait partie du cours

Introduction to BigQuery

Afficher le cours

Instructions

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.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

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

Modifier et exécuter le code