SQL Practice Logo

SQLPractice Online

Level 4 - Mid-LevelScenario-Based Questions

Finance Accrual vs Cash Variance

Return month_start and variance = invoiced_amount - paid_amount for each month in 2026.

Schema Context

invoices(id, invoice_date, amount), payments(id, payment_date, amount, status)