Capstone Challenge 1

Rank products by total revenue within each category.

💡 Strategy

Step	What to do
CTE	Join products → orderItems, SUM revenue, GROUP BY product
Main query	Apply DENSE_RANK() OVER(PARTITION BY category ORDER BY total_revenue DESC)

This is the classic "leaderboard per group" pattern you'll use in many business reports.

Requirements

• Calculate total revenue per product
• Rank within category using DENSE_RANK
• Show: category, name, total_revenue, category_rank
• Order by category, then rank