intermediateHAVING 8m est

High-Spending Customers

Problem Statement

Identify all customers who have spent a total of more than $500 across all their orders. Retrieve the customer's `name` and their `total_spent`. Sort the results by `total_spent` descending.

Skills Evaluated

GROUP BYHAVINGSUMJOIN
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.

Expected Output Format

Executing expected result set...
SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1