Problem 6 of 8 · Gaps, Islands & StreaksNext: Tolerant streaks — 1-day gap still counts as continuous

00:00

Practice / SQL / Gaps, Islands & Streaks

WorkingGuided

HardAbout 13 minGaps, Islands & StreaksLesson: Gaps, Islands & Streaks (P19) →

Longest consecutive-day login streak

Per user, find the length of their longest run of consecutive calendar days with a login. Sort by user_id.

Returnuser_idlongest_streak

Columns

logins2 columns

columntype

user_idVARCHAR

login_dateDATE

The table

8 rows · 2 columns

loginsfirst 5 of 8 rows

user_idlogin_date

u_12026-06-01

u_12026-06-02

u_12026-06-02

u_12026-06-03

u_12026-06-05

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows