SQL Practice Logo

SQLPractice Online

Level 8 - PrincipalDebugging Questionsm2 consistency transactions scale

Debug Missing GROUP BY in Settlement

Fix: SELECT merchant_id, SUM(amount) AS settled_total FROM settlements WHERE state='SETTLED';

Schema Context

settlements(settlement_id, merchant_id, amount, state, settled_at)