SQL pattern
Running Totals & Moving Averages
15 problemsin this pattern, climbing easy → medium → hard. Pick wherever you're calibrated. Read the P16 tutorial →
Easy
Medium
- NEWRunning revenue per customerSQL · ~10 min
- NEWFirst order date crossing $150 lifetime spendSQL · ~10 min
- NEWPareto: cumulative revenue share by categorySQL · ~16 min
- NEWRevenue spike check against the prior 3 daysSQL · ~10 min
- NEWDistinct buyers in trailing 7-day window per daySQL · ~12 min
- NEWTrailing 3-row MA with min-periods=3 ruleSQL · ~8 min