ComenzarEmpieza gratis

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.

Este ejercicio forma parte del curso

Reporting in SQL

Ver curso

Instrucciones del ejercicio

  • 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.

Ejercicio interactivo práctico

Prueba este ejercicio y completa el código de muestra.

-- Query sport, events, and athletes from summer_games
SELECT 
	____, 
    ____ AS events, 
    ____ AS athletes
FROM summer_games
GROUP BY ____;
Editar y ejecutar código