Exercise

Average total country medals by region

Layered calculations are when you create a basic query with an aggregation, then reference that query as a subquery to run an additional calculation. This approach allows you to run aggregations on aggregations, such as a MAX() of a COUNT() or an AVG() of a SUM().

In this exercise, your task is to pull the average total_golds for all countries within each region. This report will apply only for summer events.

To avoid having to deal with null handling, we have created a summer_games_clean table. Please use this when building the report.

Instructions 1/2

XP

1
2

Set up a query that pulls total_golds by region and country_id from the summer_games_clean and countries tables.
GROUP BY the unaggregated fields.

Take Hint (-15 XP)