Problem 3 of 8 · Gaps, Islands & StreaksNext: Longest gap between a user's logins

00:00

Practice / SQL / Gaps, Islands & Streaks

WorkingGuided

MediumAbout 8 minGaps, Islands & StreaksLesson: Gaps, Islands & Streaks (P19) →

Number of distinct login streaks per user

For each user, count how many SEPARATE consecutive-day streaks they had (a streak = a maximal run of consecutive days; gaps of any length break the streak).

Sort by user_id ascending.

Returnuser_idnum_streaks

Columns

logins2 columns

columntype

user_idVARCHAR

login_dateDATE

The table

7 rows · 2 columns

loginsfirst 5 of 7 rows

user_idlogin_date

u_12026-06-01

u_12026-06-02

u_12026-06-03

u_12026-06-05

u_12026-06-06

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