Multiple CTEs: Customer Analysis

Use multiple CTEs to perform a comprehensive customer analysis: calculate total spending and invoice count, then combine them.

Write a query with two CTEs: one for total spending, one for invoice counts. Then join them in the final query.

Schema: Customer

Schema: Invoice

Requirements:

• CTE 1 (CustomerSpending): CustomerId and TotalSpent
• CTE 2 (CustomerInvoiceCounts): CustomerId and InvoiceCount
• Join both CTEs with Customer table
• Return FirstName, LastName, TotalSpent, InvoiceCount
• Order by TotalSpent descending, then CustomerId ascending to break ties, limit to 10

Multiple CTEs Syntax:

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