SQL Cohort DAU Action Frequency | Dataford Interview Questions

Write a SQL query to find the daily active users who performed a specific action at least three times within their first week of signing up.

Use users and events. Treat action_name = 'collection_run' as the specific action. The first week includes events from signup time through, but not including, seven days after signup.

Output

One row per qualifying user and activity date
Columns: user_id, activity_date
Include only target-action activity during each qualifying user's first week
Sort by activity_date, then user_id

Schema

users

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

events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	INT	User associated with the event
action_name	VARCHAR(100)	Name of the action performed
event_at	TIMESTAMP	Timestamp when the event occurred

Your question is SQL Cohort DAU Action Frequency. 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