Return
country: the customer's countrycategory: the product categorytotal_quantity: total quantity of products ordered in this category by customers from this country
Results should include only countries and categories with at least 10 products ordered, and be ordered by country ascending, then total_quantity descending within each country.Expected output
| country | category | total_quantity |
|---|---|---|
| 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.