Rolling 30-Day MAU Actions Query | Dataford Interview Questions

Write a SQL query to find the monthly active users (MAU) who have performed a specific set of actions on New Relic's platform over a rolling 30-day period.

Use users, platform_events, and action_catalog. Treat rows marked is_required = TRUE as the required action set. Evaluate each calendar month represented in the events, using the month end as the rolling 30-day window end.

Output

One row per calendar month.
Columns: month_start and mau_user_count.
Include users who completed every required action in that month's rolling window, and order by month_start ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique New Relic user identifier
email	VARCHAR(255)	User email address
account_tier	VARCHAR(50)	New Relic account tier

platform_events

Column	Type	Description
event_idPK	INT	Unique platform event identifier
user_id	INT	User who performed the action
action_id	INT	Performed platform action
event_timestamp	TIMESTAMP	Timestamp when the action occurred
event_metadata	TEXT	Optional event details

action_catalog

Column	Type	Description
action_idPK	INT	Unique action identifier
action_name	VARCHAR(100)	Platform action name
is_required	BOOLEAN	Whether the action is required for MAU qualification
description	TEXT	Action description

Your question is Rolling 30-Day MAU Actions Query. Start with the requirements and the three 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