Find orders bigger than average

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.

Row order matters

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid