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.
Este exercício faz parte do curso
Reporting in SQL
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Query total_golds by region and country_id
SELECT
____,
____,
____ AS total_golds
FROM ____ AS s
JOIN ____ AS c
ON ____
GROUP BY ____;