medium · ~10 min
Finance needs a quarterly reconciliation comparing budget against actuals by (department, quarter).
budget
actuals
(department, quarter)
budget_amount
actual_amount
0
difference = actual_amount - budget_amount
department
quarter
difference
Input contract: (department, quarter) is unique and non-null in budget and unique and non-null in actuals.