task Medians, shares & ratios · hard

Median order value by region

An order's value is the sum of quantity × unit_price over its lines. For non-cancelled orders, return region and median_order_value per shopper region.

what to return

Columns

regionmedian_order_value in this order

Rows

4 rows · any order

Watch for

With an odd number of orders, the median is the middle value; with an even number, the average of the two middle values.

Exclude shoppers with no region.

Round to 2 decimals.

Skill

Compute a median with window functions. Refresher: Share of total with windows →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

Sample rows from each table. Each column shows its type underneath; → marks a link to another table.