Level 3 - IntermediateScenario-Based Questions
Scenario: Order-Payment Reconciliation
Finance asks for orders where paid_amount_total does not equal order_total. Return order_id, order_total, paid_amount_total.
Schema Context
orders(id, order_total), payments(id, order_id, amount, status)