#729

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.

idtotal
48000
83900
22500

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid