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.

Diese Übung ist Teil des Kurses

Introduction to BigQuery

Kurs anzeigen

Anleitung zur Übung

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.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

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 bearbeiten und ausführen