MoM Active User Growth Query | Dataford Interview Questions

Write a query to find the month-over-month growth rate of active users on a specific Internet Brands portfolio website.

Use the website identified by website_slug = 'nolo' and count distinct users with active activity records. Return available months in chronological order.

Output

One row per month with month, active_users, previous_active_users, and growth_rate_pct.
Set the first month's previous count and growth rate to NULL. Order by month ascending.

Schema

websites

Column	Type	Description
website_idPK	INT	Unique website identifier
website_slug	VARCHAR(100)	Stable website identifier used for filtering
website_name	VARCHAR(150)	Portfolio website name

user_activity

Column	Type	Description
activity_idPK	INT	Unique activity record identifier
website_id	INT	Referenced website
user_id	INT	User associated with the activity
activity_at	TIMESTAMP	Timestamp of the activity
is_active	BOOLEAN	Whether the activity qualifies as active

Your question is MoM Active User Growth Query. 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