Median Order Value per Country

medium
Unit 14 · Window Functions VII0/3 to milestone

For each country with orders, return country and median_total: the median order value. With an even number of orders, it's the mean of the two middle values. Sort by country.

Pro problem

Unlock this and every premium problem across all tracks — plus hidden-test grading, advanced AI engineering modules and new content every week.

Start 7-day free trial
query.sql · SQLite
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Median Order Value per Country · TechGradify