How it works Skills Methodology Pricing Sign In / Up

← All patterns

Pattern

Gaps & islands

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

EZ

Easy

0 / 2 solved

Flag each login row as consecutive or not
SQL · ~6 min
NEW
First and last active day per user
SQL · ~4 min
NEW

MD

Medium

0 / 3 solved

Longest consecutive-day streak per user
SQL · ~10 min
NEW
Gaps over 5 days between consecutive orders
SQL · ~8 min
NEW
Number of distinct login streaks per user
SQL · ~8 min
NEW

HD

Hard

0 / 3 solved

Tolerant streaks — 1-day gap still counts as continuous
SQL · ~12 min
NEW
Longest streak of consecutive months with revenue > $1,500
SQL · ~12 min
NEW
Longest gap between a user's logins
SQL · ~14 min
NEW