Consecutive Active Days Detection | Dataford Interview Questions

Given a table of user activity logs, write a query to identify users who had consecutive active days of website building on GoDaddy.

Filter activity to website_building events and ignore rows with a NULL user_id or activity_type. Include every streak of at least three consecutive calendar days.

Output

One row per qualifying user streak with user_id, streak_start, streak_end, and consecutive_days
Order by user_id, then streak_start ascending

Schema

user_activity_logs

Column	Type	Description
log_idPK	INTEGER	Unique activity log identifier
user_id	INTEGER	GoDaddy user identifier
activity_date	DATE	Calendar date of the activity
activity_type	VARCHAR(50)	Type of user activity

Your question is Consecutive Active Days Detection. 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