Join 3+ tables to build a denormalized analytical view
Build me the full picture: for each active sales rep, show their name, region name, product category (normalized), and total revenue. Group by rep, region, and category. I need to see where our reps are selling which product lines. Only include combinations that actually have sales.
Each hint you reveal reduces the XP you can earn. Try the query first.
Join four tables: dim_employees -> fact_sales -> dim_products and fact_sales -> dim_regions
Filter to active employees in the Sales department
GROUP BY employee name, region_name, and LOWER(category)