DAU with Three Tasks in 24 Hours | Dataford Interview Questions

Write a query to find the daily active users (DAU) who successfully completed at least three automated tasks within a 24-hour window.

Use the users and task_executions tables. Include only successful executions whose task type is automated. Treat a task completed exactly 24 hours earlier as within the window.

Output

One row per qualifying user and calendar date.
Return activity_date, user_id, and completed_tasks_in_24h.
Include only users with at least three qualifying tasks in a 24-hour window.
Order by activity_date ascending, then user_id ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
display_name	VARCHAR(100)	User display name

task_executions

Column	Type	Description
execution_idPK	INT	Unique task execution identifier
user_id	INT	User who initiated the execution
task_type	VARCHAR(30)	Execution type, such as automated or manual
status	VARCHAR(30)	Execution result status
completed_at	TIMESTAMP	Timestamp when the execution completed

Your question is DAU with Three Tasks in 24 Hours. 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