Return
id (customer's unique ID)name (customer's name)country (customer's country)total_spent (sum of all spending by the customer)Expected output
| id | name | country | total_spent |
|---|---|---|---|
| 1 row — values hidden, that's the puzzle | |||
Your query should return 1 row with these columns. Your column aliases don't need to match.