Reconcile a summary against raw rows

Finance reports a mismatch; reproduce the defect and write a reconciliation query that pinpoints orders whose stored total disagrees with their lines.

1. 1Reproduce the defect: UPDATE orders SET total = total + 10 WHERE id = 5.
2. 2Join orders to order_items and group per order.
3. 3Return id, total, ROUND(SUM(quantity * unit_price), 2) AS items_total and ROUND(total - SUM(quantity * unit_price), 2) AS difference.
4. 4Keep only orders where the absolute difference exceeds 0.005.

• The last result set lists exactly the corrupted order with its 10.00 difference
• The query filters groups with HAVING

• Every run starts from a freshly seeded database, so your script must include its own setup statements.
• Only the last result set of your script is compared, so finish with the verification query.