MoM Growth Rate Query | Dataford Interview Questions

Write a query to find the month-over-month growth rate of active checking accounts at Axos Bank.

Use the account product type and monthly account status snapshots to calculate the metric. Include only months with a directly preceding month available for comparison. Rows with a NULL product type or status are ignored.

Output

One row per month with a preceding month in the data.
Columns: month_start, active_checking_accounts, prior_month_active_checking_accounts, and mom_growth_rate_pct.
Report the growth rate as a percentage rounded to two decimal places, ordered by month_start ascending.

Schema

bank_accounts

Column	Type	Description
account_idPK	INT	Unique bank account identifier
customer_id	INT	Axos Bank customer identifier
product_type	VARCHAR(30)	Banking product category
opened_date	DATE	Date the account was opened

account_snapshots

Column	Type	Description
snapshot_idPK	INT	Unique account snapshot identifier
account_id	INT	Referenced bank account identifier
snapshot_date	DATE	Date of the account status snapshot
status	VARCHAR(30)	Account status recorded at the snapshot date

Your question is MoM Growth Rate 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