Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Customers With Above-Average Order Value

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.