SQLDAXExcelPython
Leaderboard
Group and aggregateMedium20 points

Sale size buckets

Label each sale by Amount: Small under 5000, Medium from 5000 up to but not including 25000, and Large from 25000 up. Return each label and how many sales have it.

Show solutionLifetime

Runs in your browser with DuckDB, whose SQL is close to PostgreSQL. Nothing you type is sent to a server unless you save a score.

SQLselect text to run only that part
Loading editor…

Press Ctrl+Enter or Run to see the result here.