Session Ready
Exercise

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 the countries 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).
Instructions 1/3
undefined XP
  • 1
  • 2
  • 3
  • Pull country_id and height for winter athletes, group by these two fields, and order by country_id and height in descending order.
  • Use ROW_NUMBER() to create row_num, which numbers rows within a country by height where 1 is the tallest.