1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to BigQuery
Connected

Exercise

Using joins

In many data warehouses, including BigQuery, data is stored in various tables linked by common keys across the table. This is the case with the course data, which mimics a real-world data warehouse.

For this exercise, you will combine two tables to create a single outcome.

Instructions

100 XP
  • Join the ecomm_orders to the ecomm_order_details using the common order_id column.
  • Order the dataset by order_purchase_timestamp to show the most recent orders.