Joining and aggregating retail data

Your team at Global Retail Analytics wants to understand revenue patterns across regions. A new CSV file called country_lookup.csv has been added to the datasets volume, mapping each country to its region and currency.

You'll enrich the online_retail data with this lookup dataset using a broadcast join, verify the query plan, and aggregate revenue by region.