Consecutive Activity Days | Dataford Interview Questions

Given a table of Pluralsight user login events, write a SQL query to identify consecutive days of platform activity for active learners. Treat multiple login events on the same calendar day as one activity day. Return only streaks containing at least two consecutive calendar days.

Output

One row per learner streak
Columns: learner_id, streak_start, streak_end, and consecutive_days
Exclude null learners and invalid login timestamps
Order by learner_id, then streak_start

Schema

login_events

Column	Type	Description
event_idPK	INT	Unique identifier for the login event
learner_id	INT	Identifier of the learner associated with the event
login_at	TIMESTAMP	Timestamp when the learner logged in

Your question is Consecutive Activity Days. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Output

One row per learner streak
Columns: learner_id, streak_start, streak_end, and consecutive_days
Exclude null learners and invalid login timestamps
Order by learner_id, then streak_start

Schema

login_events

Column	Type	Description
event_idPK	INT	Unique identifier for the login event
learner_id	INT	Identifier of the learner associated with the event
login_at	TIMESTAMP	Timestamp when the learner logged in

Your question is Consecutive Activity Days. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.