Your question is Reconcile Mismatched Financial Reports. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
You are given two monthly financial reports that should align by report_date, account_id, and metric_name, but some rows do not match. Write a PostgreSQL query that compares the reports and returns every row where the records are missing on one side or the amounts differ.
For each discrepancy, return the key fields, the amount from each report, and a reconciliation_status showing whether the row is missing_in_report_a, missing_in_report_b, or amount_mismatch.
| Column | Type | Description |
|---|---|---|
| report_date | DATE | Reporting date |
| account_id | INT | Account identifier |
| metric_name | VARCHAR(50) | Financial metric name |
| amount | NUMERIC(12,2) | Amount from report A |
| Column | Type | Description |
|---|---|---|
| report_date | DATE | Reporting date |
| account_id | INT | Account identifier |
| metric_name | VARCHAR(50) | Financial metric name |
| amount | NUMERIC(12,2) | Amount from report B |