Intermediate · 30 min · 4 steps
Matching what customers paid with what the bank received
Rohan Varma, Ledger Infrastructure Engineer at PayWave Digital
It is 7:15 AM on the first Monday of the financial quarter. Rohan Varma, an engineer at PayWave, opens the control dashboard to check the overnight money report. PayWave handles over 14 million mobile recharges, bill payments and shop payments every day across India. Normally a script runs at 2:00 AM to match each order with what the bank received.
The question
Which paid orders have no captured payment, or a captured amount that does not match the order total?
- LEFT JOIN
- CASE WHEN
- Ledger reconciliation
- NULL handling
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.