By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| trd_nbr | date | amount | txn_typ |
|---|---|---|---|
| 1 | 2/5/21 | 4000.0000 | A |
| 1 | 2/5/21 | -4000.0000 | B |
| 1 | 2/5/21 | 2000.0000 | C |
| 1 | 2/5/21 | 2000.0000 | C |
| 2 | 8/12/21 | 10000.0000 | A |
| 2 | 8/12/21 | -5000.0000 | B |
| 2 | 8/12/21 | 5000.0000 | C |
| 3 | 4/3/20 | 6000.0000 | A |
| 3 | 4/3/20 | -6000.0000 | B |
| 3 | 4/3/20 | 2000.0000 | C |
| trd_nbr | Final_C_amount |
|---|---|
| 1 | 4000.0000 |
| 2 | 5000.0000 |
| 3 | 4000.0000 |