Advanced · SQL · Data quality

Orders whose payments don't match the total

Commonly asked: Payment reconciliation checks in fintech/e-commerce QA · ~12 min

Return order_id, total and paid (sum of CAPTURED payment amounts) for orders where paid differs from total by more than 0.01.