Median vs Average Order Value

Medium

Description

For delivered orders, show in one row:

orders: how many there are
avg_order: the average total_amount
median_order: the median total_amount, the middle value once the amounts are sorted. With an even number of orders, it's the average of the two middle values.

Round avg_order and median_order to 2 decimal places.

Medium

For delivered orders, show in one row:

orders: how many there are
avg_order: the average total_amount
median_order: the median total_amount, the middle value once the amounts are sorted. With an even number of orders, it's the average of the two middle values.

Round avg_order and median_order to 2 decimal places.

orders	avg_order	median_order
114	11155.81	11083.78

Medium

For delivered orders, show in one row:

orders: how many there are
avg_order: the average total_amount
median_order: the median total_amount, the middle value once the amounts are sorted. With an even number of orders, it's the average of the two middle values.

Round avg_order and median_order to 2 decimal places.

Medium

For delivered orders, show in one row:

orders: how many there are
avg_order: the average total_amount
median_order: the median total_amount, the middle value once the amounts are sorted. With an even number of orders, it's the average of the two middle values.

Round avg_order and median_order to 2 decimal places.