Find orders bigger than average
The CFO wants to spot «big tickets» — orders whose total beats the average across paid orders (status = 'paid'). Cancelled orders don't go into the average, otherwise it'd be skewed. Return the id and total of such orders, sort by total descending.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| id | total |
|---|---|
| 4 | 8000 |
| 8 | 3900 |
| 2 | 2500 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid