Rolling Three-Month Recovery SQL | Dataford Interview Questions

Write a query that aggregates monthly recovery amounts and calculates a rolling three-month average for PRA Group.

Use the recovery_payments table and include only rows with a posted status. For this exercise, the rolling average includes the current month and up to the two preceding months in the monthly result.

Output

One row per recovery month, formatted as YYYY-MM.
Columns: recovery_month, monthly_recovery, and rolling_three_month_avg.
Sort chronologically by recovery month.

Schema

recovery_payments

Column	Type	Description
payment_idPK	INT	Unique recovery payment identifier
recovery_date	DATE	Date the payment was recorded
amount	DECIMAL(12,2)	Recovery amount
status	VARCHAR(20)	Payment processing status

Your question is Rolling Three-Month Recovery SQL. Start with the requirements and the one table 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

Write a query that aggregates monthly recovery amounts and calculates a rolling three-month average for PRA Group.

Output

One row per recovery month, formatted as YYYY-MM.
Columns: recovery_month, monthly_recovery, and rolling_three_month_avg.
Sort chronologically by recovery month.

Schema

recovery_payments

Column	Type	Description
payment_idPK	INT	Unique recovery payment identifier
recovery_date	DATE	Date the payment was recorded
amount	DECIMAL(12,2)	Recovery amount
status	VARCHAR(20)	Payment processing status

Your question is Rolling Three-Month Recovery SQL. Start with the requirements and the one table 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.