Code AnalysisHard 60s
Reconciliation Missing Rows Bug
SQL:
SELECT p.id
FROM provider_settlements p
JOIN ledger_entries l ON l.ref = p.ref
WHERE p.amount <> l.amount;
What internal discrepancy does this query fail to detect?
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.