SQL pattern · 5 problems

Percentiles & median

Graded problems on percentiles & median, from easy to hard.

5 problems · about 35 min in all
Start with problem 01Median order amount per customer · 6 min

Easy

2 problems · about 10 min
01Median order amount per customer6 min →02Mean vs median order amount4 min →

Medium

2 problems · about 17 min
03Price quartiles (p25, p50, p75) per category7 min →04Interpolated vs actual median per status10 min →

Hard

1 problem · about 8 min
05Median days from signup to first order8 min →