Problem Statement
Calculate the total spending for each customer and rank them from highest spender to lowest. Display the customer's `name`, their `total_spent`, and their rank using `DENSE_RANK() OVER (...)` aliased as `spending_rank`.
Skills Evaluated
DENSE_RANKGROUP BYWindow Functions
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