How it works Skills Methodology Pricing Sign In / Up

← All patterns

Pattern

Pivot & unpivot

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

MD

Medium

0 / 5 solved

Pivot monthly revenue into category columns
SQL · ~8 min
NEW
Total revenue per category as columns
SQL · ~7 min
NEW
Order counts by status as columns
SQL · ~8 min
NEW
Electronics revenue share per month
SQL · ~9 min
NEW
Unpivot category totals back to long form
SQL · ~10 min
NEW

HD

Hard

0 / 5 solved

Pivot revenue into category columns per customer
SQL · ~14 min
NEW
Category × month crosstab with row totals
SQL · ~12 min
NEW
Two metrics per category in one pivot
SQL · ~13 min
NEW
Pivot: zero vs. NULL for missing buckets
SQL · ~12 min
NEW
Per-customer order counts by status
SQL · ~11 min
NEW