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

View Course

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 ____;

Edit and Run Code