Pro exercise

Aggregate through a dimension table

Revenue must be reported by region, but sales only carry a store code. Attach each store's region from the store table, report sales for unknown stores, and total revenue per region.

joins
aggregation
dimensions