1. Learn
    2. /
  2. Courses
    3. /
  3. Reporting in SQL

Exercise

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.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Select event from the summer_games table and create the athletes field by counting the distinct number of athlete_id.