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.