SQLDAXExcelPython
Leaderboard
Interview classicsMedium20 points

Median sale amount

Return the median of Amount in Sales. Not every database has a MEDIAN function, so also think about how you would do it with window functions.

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.