1. Learn
    2. /
  2. Courses
    3. /
  3. Reporting in SQL

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

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