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.

This exercise is part of the course

Introduction to BigQuery

View Course

Exercise 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.

Hands-on interactive exercise

Have a go at this exercise by completing this sample 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

Edit and Run Code