MAU Action Query in Lucidchart | Dataford Interview Questions

Lucid monitors monthly active users who edit templates in Lucidchart. Write a SQL query to calculate the number of distinct users who performed a template_edit action on Lucidchart templates during each of the six calendar months from April through September 2026.

Output

One row per calendar month with activity, using the first day of the month as activity_month.
Columns: activity_month and mau, where mau is the number of distinct users who performed the qualifying action.
Include only template_edit events associated with the Lucidchart product, and order rows by activity_month ascending.

Schema

template_events

Column	Type	Description
event_idPK	INTEGER	Unique event identifier
user_id	INTEGER	User who performed the action
template_id	INTEGER	Template associated with the event
action_name	VARCHAR(50)	Action performed by the user
occurred_at	TIMESTAMP	Timestamp when the action occurred

templates

Column	Type	Description
template_idPK	INTEGER	Unique template identifier
product_name	VARCHAR(40)	Lucid product containing the template
template_name	VARCHAR(100)	Display name of the template

Your question is MAU Action Query in Lucidchart. 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