Back to Interview SQL Patterns

Consecutive Days, Sessions — Gaps and Islands

The pattern behind 'consecutive logins', 'session detection', 'streaks' — one of the SQL world's named techniques. FIND_VIDEO: search 'SQL gaps and islands consecutive days' — recommended channel: Itzik Ben-Gan / Modern SQL. Aim for 12 min or under.

12 minutesVideo Lesson
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.

Ready to continue?

Mark this lesson as complete when you're ready to proceed.