MAU With Event Frequency | Dataford Interview Questions

Write a SQL query to find the monthly active users who signed up in the last 90 days and have performed a specific event more than five times.

Assume the specific event is docker_desktop_download. Use the current date to determine the 90-day signup window.

Output

One row per activity month.
Columns: activity_month and active_users.
Include only months containing users who performed the specified event more than five times during that month.
Order by activity_month ascending.

users

events

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

Your question is MAU With Event 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.

Write a SQL query to find the monthly active users who signed up in the last 90 days and have performed a specific event more than five times.

Assume the specific event is docker_desktop_download. Use the current date to determine the 90-day signup window.

One row per activity month.
Columns: activity_month and active_users.
Include only months containing users who performed the specified event more than five times during that month.
Order by activity_month ascending.

users

events

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

Your question is MAU With Event 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.