Practice intermediate SQL question: Customers Above a Spending Threshold (CTE)

Solve this interactive intermediate question online in our browser coding environment.

Customers Above a Spending Threshold (CTE)

intermediate~7 min25 pts

Problem

Using a CTE, first compute each customer's total spending (sum of their invoice totals). Then, from that CTE, return only the customers whose total spending exceeds $40.

Return CustomerId, FirstName, LastName, and TotalSpent, ordered by TotalSpent descending (ties broken by CustomerId ascending).

Schema: Customer

Column	Type
CustomerId	INTEGER (Primary Key)
FirstName	TEXT
LastName	TEXT

Schema: Invoice

Column	Type
InvoiceId	INTEGER (Primary Key)
CustomerId	INTEGER (Foreign Key -> Customer.CustomerId)
InvoiceDate	TIMESTAMP
Total	NUMERIC(10,2)

CTE aggregation JOIN

📊

📊 View Question Telemetry & Insights

Failure rate, silent bug autopsy & optimal query construction

Inspect →

Master SQL & Data Analytics

Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.

Explore the 12-Week Data Analyst Career Track

Customers Above a Spending Threshold (CTE)

intermediate~7 min25 pts

📊 View Insights

Problem

Using a CTE, first compute each customer's total spending (sum of their invoice totals). Then, from that CTE, return only the customers whose total spending exceeds $40.

Return CustomerId, FirstName, LastName, and TotalSpent, ordered by TotalSpent descending (ties broken by CustomerId ascending).