Athletes vs events by sport
Now consider the following visualization:
Using the summer_games table, run a query that creates the base report that sources this visualization.
Deze oefening maakt deel uit van de cursus
Reporting in SQL
Oefeninstructies
- Pull a report that shows each sport, the number of unique events, and the number of unique athletes from the
summer_gamestable. - Group by the non-aggregated field, which is
sport.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Query sport, events, and athletes from summer_games
SELECT
____,
____ AS events,
____ AS athletes
FROM summer_games
GROUP BY ____;