JOIN then UNION query

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

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.

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.