Exercise

Joins with aggregations

Joins in BigQuery are often combined with aggregations. For example, imagine you have a very long table like our orders table, which has many entries and can expand over time, and our products table, which has fewer entries.

In this exercise, you must count the number of orders per product.

Instructions

100 XP

Count the number of orders for each product_id in the ecomm_products dataset.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise