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

Exercise

JOIN then UNION query

Your goal is to create a report with the following fields:

  • season, which outputs either summer or winter
  • country
  • events, which shows the unique number of events

There are multiple ways to create this report. In this exercise, create the report by using the JOIN first, UNION second approach.

As always, feel free to reference your E:R Diagram to identify relevant fields and tables.

Instructions

100 XP
  • Setup a query that shows unique events by country and season for summer events.
  • Setup a similar query that shows unique events by country and season for winter events.
  • Combine the two queries using a UNION ALL.
  • Sort the report by events in descending order.