Refund Adjusted Revenue

Problem

Return net_revenue as total order amount minus total refunded amount.

Why This Matters

SQL interviews usually test whether you can turn a business question into the right rows, grouping level, join type, and edge-case behavior.

Schema

orders(order_id INTEGER, amount INTEGER); refunds(refund_id INTEGER, order_id INTEGER, amount INTEGER)

Examples

Constraints

• Return only the requested columns.
• Use deterministic ORDER BY when multiple rows are returned.
• Assume SQLite-compatible SQL unless the prompt states otherwise.