Report 2: Top athletes in nobel-prized countries
It's time to bring together all the concepts brought up in this chapter to expand on your dashboard! Your next report to build is Report 2: Athletes Representing Nobel-Prize Winning Countries.
Report Details:
- Column 1 should be
event
, which represents the Olympic event. Both summer and winter events should be included. - Column 2 should be
gender
, which represents the gender of athletes in the event. - Column 3 should be
athletes
, which represents the unique athletes in the event. - Athletes from countries that have had no
nobel_prize_winners
should be excluded. - The report should contain 10 events, where events with the most
athletes
show at the top.
Click to view the E:R Diagram.
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.
-- Pull event and unique athletes from summer_games
SELECT
____,
____ AS athletes
FROM ____
GROUP BY ____;