SQL for First-Week Action Repeaters | Dataford Interview Questions

Write a query to find the monthly active users (MAU) who performed a specific action at least three times in their first week of signing up for GitHub.

Assume the specific action is repository_created. A user qualifies after at least three such events within seven days of signup, and is counted in every calendar month where they perform that action.

Output

One row per calendar month with at least one qualifying user.
Columns: activity_month in YYYY-MM format and mau_count.
Sort by activity_month ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique GitHub user identifier
signup_at	TIMESTAMP	Timestamp when the user signed up

user_events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	INT	User associated with the event
action_name	VARCHAR(100)	Action performed by the user
event_timestamp	TIMESTAMP	Timestamp when the action occurred

Your question is SQL for First-Week Action Repeaters. Start with the requirements and the two tables 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