Customers With Above-Average Order Value
Medium
Correlated Subqueries
Return customers whose average order amount is higher than the average amount of all orders. Order by customer.
Table schema
Orders(id INT PRIMARY KEY, customer VARCHAR(10), amount INT)Sample data
id | customer | amount
1 | Ann | 100
2 | Ann | 200
3 | Bob | 50
4 | Bob | 70
5 | Cy | 300
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.