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.

Select event from the summer_games table and create the athletes field by counting the distinct number of athlete_id.

Exercise

Report 2: Top athletes in nobel-prized countries

Instructions 1/4