Business Intelligence Path · Mission 16 of 31Hard

Top 2 products per category

Use ROW_NUMBER() with PARTITION BY to solve top-N per group problems

Unlock with Pro→Back to Business Intelligence

The Brief

You'll practice

ROW_NUMBER()PARTITION BYTop-N
← Previous
Mission 15
Next →
Mission 17
All 31 missions in Business Intelligence Path ↓
  1. 1. Board deck needs revenue by quarter
  2. 2. Who is hitting their sales targets?
  3. 3. Product mix is shifting
  4. 4. Which region should we expand next?
  5. 5. The dashboard numbers don't add up
  6. 6. Discount tiers need a reality check
  7. 7. Which categories are actually selling well?
  8. 8. Find reps outselling their department average
  9. 9. How many unique customers per region?
  10. 10. Tag every sale by size
  11. 11. Rank the sales team
  12. 12. Who reports to whom?
  13. 13. Monthly revenue trend with growth rate
  14. 14. Pivot revenue by category and year
  15. 15. Tenure and salary — any correlation?
  16. 16. Top 2 products per category
  17. 17. Find products with no sales last quarter
  18. 18. Three-table join: who sold what where?
  19. 19. Correlated check: reps beating their own average
  20. 20. Running revenue total by month
  21. 21. Year-over-year revenue by quarter
  22. 22. Three-month moving average
  23. 23. Hire cohort performance analysis
  24. 24. Percentile ranking across the sales force
  25. 25. The executive summary query
  26. 26. Why is our leaderboard off by 12x?
  27. 27. YoY revenue decomposition — price vs volume
  28. 28. Tenure-adjusted attainment scorecard
  29. 29. Dirty-dim audit — category casing reconciliation
  30. 30. Same-rep regional growth — apples-to-apples YoY
  31. 31. BI executive capstone — board KPI panel