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

Exercise

Report 1: Most decorated summer athletes

Now that you have a good understanding of the data, let's get back to our case study and build out the first element for the dashboard, Most Decorated Summer Athletes:

Your job is to create the base report for this element. Base report details:

  • Column 1 should be athlete_name.
  • Column 2 should be gold_medals.
  • The report should only include athletes with at least 3 medals.
  • The report should be ordered by gold medals won, with the most medals at the top.

Instructions

100 XP
  • Select athlete_name and gold_medals by joining summer_games and athletes.
  • Only include athlete_name with at least 3 gold medals.
  • Sort the table so that the most gold_medals appears at the top.