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.