ExtraCash MoM Active User Growth | Dataford Interview Questions

Write a query to find the month-over-month growth rate of active users who have taken out an ExtraCash advance.

Use the users and extracash_advances tables. Count distinct users with an active account and a funded ExtraCash advance in each calendar month. Include months with no qualifying users when they fall between the first and last relevant advance month.

Output

One row per calendar month, ordered chronologically.
Columns: month_start, active_users, and mom_growth_rate.
Return the growth rate as a percentage rounded to two decimal places. Return NULL when no prior-month comparison is available or the prior month has zero active users.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Dave user identifier
account_status	VARCHAR(20)	Current account status

extracash_advances

Column	Type	Description
advance_idPK	INT	Unique ExtraCash advance identifier
user_id	INT	User who requested the advance
product	VARCHAR(30)	Advance product name
advance_status	VARCHAR(20)	Current advance status
advance_date	DATE	Date the advance was issued or requested

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