Get startedGet started for free

Building the base report

Now, build the base report for this visualization:

This should be built by querying the summer_games table, found in the explorer on the bottom right.

This exercise is part of the course

Reporting in SQL

View Course

Exercise instructions

  • Using the console on the right, select the sport field from the summer_games table.
  • Create athletes by counting the distinct occurrences of athlete_id.
  • Group by the sport field.
  • Make the report only show 3 rows, with the highest athletes at the top.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Query the sport and distinct number of athletes
SELECT 
	____, 
    ____ AS athletes
FROM summer_games
GROUP BY ____
-- Only include the 3 sports with the most athletes
ORDER BY ____
LIMIT ____;
Edit and Run Code