Return
name (the customer's name)country (the customer's country)order_count (the number of distinct orders placed by the customer)total_spend (the sum of the customer's spending, calculated as quantity times unit price for all their order items)total_spend from highest to lowest.Expected output
| name | country | order_count | total_spend |
|---|---|---|---|
| 2 rows — values hidden, that's the puzzle | |||
Your query should return 2 rows with these columns. Your column aliases don't need to match.