SQL Practice Logo

SQLPractice Online

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)