Number of events in each sport

The full E:R diagram for the database is shown below:

Since the company will be involved in both summer sports and winter sports, it is beneficial to look at all sports in one centralized report.

Your task is to create a query that shows the unique number of events held for each sport. Note that since no relationships exist between these two tables, you will need to use a UNION instead of a JOIN.

Cet exercice fait partie du cours

Reporting in SQL

Afficher le cours

Instructions

Create a report that shows unique events by sport for both summer and winter events.
Use a UNION to combine the relevant tables.
Use two GROUP BY statements as needed.
Order the final query to show the highest number of events first.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Select sport and events for summer sports
SELECT 
	____, 
    ____(____ ____) AS events
FROM ____
____
UNION
-- Select sport and events for winter sports
SELECT 
	____, 
    ____
FROM ____
____
-- Show the most events at the top of the report
____;

Modifier et exécuter le code