## A. Structure check | Table | Columns found | Row count | |---|---|---:| | Left | order_id, customer, amount | 5 | | Right | order_id, amount | 5 | Required key column `order_id` exists in both tables. Compare column `amount` exists in both tables. ## B. Key check | Check | Left | Right | |---|---|---| | Duplicate keys | None | None | | Blank keys | None | None | ## C. Paired rows that fully match | order_id | Left amount | Right amount | |---|---:|---:| | ORD-1001 | 45.00 | 45.00 | | ORD-1003 | 32.50 | 32.50 | ## D. Only in the left table | order_id | customer | amount | |---|---|---:| | ORD-1005 | Jung | 75.00 | ## E. Only in the right table | order_id | amount | |---|---:| | ORD-1007 | 69.00 | ## F. Field mismatches | Key | Column | Left value | Right value | Type | |---|---|---:|---:|---| | ORD-1002 | amount | 60.00 | 58.00 | OUT | ## G. Number differences Tolerance for `amount`: **0.10** Difference = right − left. | Key | Column | Left | Right | Difference | Result | |---|---|---:|---:|---:|---| | ORD-1002 | amount | 60.00 | 58.00 | -2.00 | OUT | | ORD-1004 | amount | 28.90 | 28.85 | -0.05 | WITHIN | `ORD-1004` differs numerically, but the absolute difference of `0.05` is within the allowed tolerance of `0.10`. ## H. Totals reconciliation and row-count check ### Amount totals | Item | Amount | |---|---:| | Left total | 241.40 | | Right total | 233.35 | | Right total − Left total | -8.05 | Skipped from left total: **0** values. Skipped from right total: **0** values. ### Row-count check | Table | Paired rows | One-sided rows | Duplicate-key rows | Accounted total | Actual row count | |---|---:|---:|---:|---:|---:| | Left | 4 | 1 | 0 | 5 | 5 | | Right | 4 | 1 | 0 | 5 | 5 | Row-count checks pass for both tables. ## I. VERIFY items None. No left-only and right-only keys differ only by leading zeros. ## J. Final status: MISMATCH **MISMATCH — there is one left-only row, one right-only row, and `ORD-1002` has an `amount` difference outside the 0.10 tolerance.** Continue checking the reconciliation - Review unmatched keys - Recalculate totals by key group