Practice · easy · dataset: ecom
High-volume customers
Account managers want customers with more than five orders. Return customer_id, email, and
order_count for each such customer, counting only real orders.
Sort by order_count descending, then by customer_id ascending.
Tables available
| Table | Columns |
|---|---|
customers |
customer_id, email, country, signup_date |
orders |
order_id, customer_id, order_date, status, channel |
A customer with exactly five orders is not included; the threshold is strictly greater than five.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.