Capstone Challenge 1

Find the top 5 customers by total revenue using a CTE.

💡 Strategy

Think about this in two steps:

• Calculate total revenue per customer (CTE)
• Rank and limit the results (main query)

Your CTE needs to join three tables to get from customers → orders → individual items:

customers ←→ orders ←→ orderItems
   name      status    quantity × unitPrice = revenue

Requirements

• Create a CTE that calculates total revenue per customer
• Only include completed orders
• Show: customer name, region, total_revenue
• Order by total_revenue descending, limit to 5