How it works Skills Methodology Pricing Sign In / Up

← All patterns

Pattern

Percentiles & median

8 problemsin this pattern, climbing easy → medium → hard. Pick wherever you're calibrated.

EZ

Easy

0 / 2 solved

Median order amount per customer
SQL · ~6 min
NEW
Mean vs median order amount
SQL · ~4 min
NEW

MD

Medium

0 / 3 solved

Price quartiles (p25, p50, p75) per category
SQL · ~7 min
NEW
Median days from signup to first order
SQL · ~8 min
NEW
Per-customer median attached to every order row
SQL · ~8 min
NEW

HD

Hard

0 / 3 solved

Median per customer WITHOUT PERCENTILE_CONT (portable)
SQL · ~15 min
NEW
Percentile rank of a $250 order in the distribution
SQL · ~8 min
NEW
Median and p90 order amount per status
SQL · ~14 min
NEW