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

Exercise

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.

Instructions

100 XP
  • Pull a report that shows each sport, the number of unique events, and the number of unique athletes from the summer_games table.
  • Group by the non-aggregated field, which is sport.