A wallet ledger has CREDIT (adds amount), DEBIT (subtracts amount) and RESET entries. A RESET (a compliance sweep) sets the balance to exactly 0; the amount stored on a RESET row must be ignored. Entries are processed in entry_time order, ties broken by entry_id. Balances may go negative. Return entry_id, user_id, entry_type and balance_after (wallet balance right after that entry, ROUND to 2) for every entry. Order by user_id, entry_time, entry_id.
| Column | Type |
|---|---|
| entry_id | INTEGER |
| user_id | INTEGER |
| entry_time | TIMESTAMP |
| entry_type | TEXT |
| amount | REAL |
| entry_id | user_id | entry_time | entry_type | amount |
|---|---|---|---|---|
| 1 | 7 | 2026-01-02 09:00:00 | CREDIT | 500 |
| 2 | 7 | 2026-01-03 12:00:00 | DEBIT | 120 |
| 3 | 7 | 2026-01-10 08:00:00 | CREDIT | 200 |
| 4 | 7 | 2026-01-15 00:00:00 | RESET | NULL |
| 5 | 7 | 2026-01-16 10:00:00 | CREDIT | 50 |
| 6 | 9 | 2026-01-05 10:00:00 | CREDIT | 1000 |
| 7 | 9 | 2026-01-06 10:00:00 | DEBIT | 250.5 |
| 8 | 9 | 2026-01-07 10:00:00 | DEBIT | 100 |
| entry_id | user_id | entry_type | balance_after |
|---|---|---|---|
| 1 | 7 | CREDIT | 500 |
| 2 | 7 | DEBIT | 380 |
| 3 | 7 | CREDIT | 580 |
| 4 | 7 | RESET | 0 |
| 5 | 7 | CREDIT | 50 |
| 6 | 9 | CREDIT | 1000 |
| 7 | 9 | DEBIT | 749.5 |
| 8 | 9 | DEBIT | 649.5 |
Solve it in the live editor on this page — run on sample data, then submit against hidden tests.
‹ Payment Success Funnel by Method · Cohort LTV by First Purchase Month ›
{{ totalCount }} questions in the style asked at Amazon, Microsoft, Google, Meta, Flipkart and more — {{ hardPct }}% Hard. Write SQL in a real database engine in your browser, run it on sample data, then evaluate against hidden tests.
Company tags show where this type of question is commonly reported in interviews. Questions, data and solutions are written by TechTown.
{{ cur.statement }}
No submissions yet. Press Evaluate to submit your query.
{{ solutionSql }}
{{ out.error }}
You have solved your 3 free questions — nice work! Log in (free) to unlock all 150 questions, keep your streak and appear on the leaderboard.