Multiple CTEs

You can define multiple CTEs separated by commas:

WITH 
    cte1 AS (SELECT ...),
    cte2 AS (SELECT ... FROM cte1)
SELECT * FROM cte2;

Later CTEs can reference earlier ones!

Your Task

Create two CTEs:

• order_totals - Calculate total per order:

- orderId, total (sum of quantity * unitPrice)

• customer_totals - Calculate total per customer:

- Join orders with order_totals - Group by customerId, sum the totals

Finally, join with customers to show name and total_spent for customers who spent over $200.