SQL for Operational KPI Tracking | Dataford Interview Questions

Write a SQL query to track monthly operational KPIs by region at the United Nations, including joins across program, finance, and staffing tables, and calculate month-over-month changes.

Use the supplied tables and include data from January through March 2025.

Output

One row per region and month, with region, month_start, program_count, total_expenditure_usd, total_active_staff, expenditure_mom_change_pct, and staff_mom_change_pct.
Include all regions with finance records in the period. Return NULL for a percentage change when there is no prior value or the prior value is zero.
Order by region, then month_start ascending.

Schema

programs

Column	Type	Description
program_idPK	INT	Unique program identifier
program_name	VARCHAR(150)	United Nations program name
region	VARCHAR(80)	Operational region

finance_monthly

Column	Type	Description
finance_idPK	INT	Unique finance record identifier
program_id	INT	Related program identifier
month_start	DATE	First day of the reporting month
expenditure_usd	NUMERIC(14,2)	Monthly expenditure in US dollars

staffing_monthly

Column	Type	Description
staffing_idPK	INT	Unique staffing record identifier
program_id	INT	Related program identifier
month_start	DATE	First day of the reporting month
active_staff	INT	Active staff count for the month

Your question is SQL for Operational KPI Tracking. Start with the requirements and the three 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