Hard
HAVING
Pro Challenge
Customers With At Least 5 Orders
Return customers who placed at least 5 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
Preparing the interactive SQL workspace...
Challenge overview
What you will practice
Return customers who placed at least 5 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
- Difficulty
- Advanced
- SQL concept
- HAVING