Loan Originations MoM Growth | Dataford Interview Questions

Write a query to find the month-over-month growth rate of loan originations by marketing channel at Prosper Marketplace.

Use the origination amount and origination timestamp. Exclude records that cannot be associated with a recognized marketing channel.

Output

One row per recognized marketing channel and month with originations.
Columns: channel_name, originations_month, total_originations, mom_growth_rate.
Show the earliest month first for each channel. The first month’s growth rate should be NULL.

marketing_channels

Column	Type	Description
channel_idPK	INT	Unique marketing channel identifier
channel_name	VARCHAR(100)	Prosper Marketplace marketing channel name

loan_originations

Column	Type	Description
origination_idPK	INT	Unique loan origination identifier
channel_id	INT	Marketing channel associated with the origination
originated_at	TIMESTAMP	Timestamp when the loan was originated
origination_amount	DECIMAL(14,2)	Loan amount originated

Your question is Loan Originations MoM 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.