SQL Month-over-Month Growth | Dataford Interview Questions

Write a SQL query to calculate month-over-month growth rates for loan applications at Rupeek. Use the supplied monthly reporting periods and loan application records. Include months with no applications and return a NULL growth rate when no prior month exists or the prior count is zero.

Output

One row per reporting month
Columns: month_start, application_count, and mom_growth_rate
Growth should be expressed as a percentage rounded to two decimal places
Sort by month_start ascending

Schema

reporting_months

Column	Type	Description
month_startPK	DATE	First calendar day of a reporting month

loan_applications

Column	Type	Description
application_idPK	INT	Unique loan application identifier
submitted_at	TIMESTAMP	Timestamp when the loan application was submitted

Your question is SQL Month-over-Month 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