Report 4: Tallest athletes and % GDP by region
The final report on the dashboard is Report 4: Avg Tallest Athlete and % of world GDP by Region.
Report Details:
- Column 1 should be
region
found in thecountries
table. - Column 2 should be
avg_tallest
, which averages the tallest athlete from each country within the region. - Column 3 should be
perc_world_gdp
, which represents what % of the world's GDP is attributed to the region. - Only
winter_games
should be included (no summer events).
This exercise is part of the course
Reporting in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Pull in country_id and height
____,
____,
-- Number the height of each country's athletes
____ AS row_num
FROM ____ AS w
JOIN ____ AS a
ON ____
GROUP BY ____, ____
-- Order by country_id and then height in descending order
ORDER BY ____, ____ DESC;