quantity times unit_price for all their orders), and the total amount spent. Include only countries where at least one order has been placed. If more than one customer in a country shares the top spending amount, include them all.Return
country: the country namecustomer_name: the name of the highest-spending customertotal_spent: the total amount spent by that customercountry and then customer_name, both alphabetically.Expected output
| country | customer_name | total_spent |
|---|---|---|
| 3 rows — values hidden, that's the puzzle | ||
Your query should return 3 rows with these columns. Your column aliases don't need to match.