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
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid