By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Account_Number | Maturity_Date | Interest_Charged_Date | Transaction_Amount | Balance | NEW_Column | NEW_Column2 |
---|---|---|---|---|---|---|
12345 | 12/09/2016 | 12/05/2016 | 0.00 | 100 | 100.00 | 100.00 |
12345 | 12/09/2016 | 12/06/2016 | 28.77 | 0 | 128.77 | 128.77 |
12345 | 12/09/2016 | 12/07/2016 | -28.83 | 0 | 99.94 | 99.94 |
12345 | 12/09/2016 | 12/08/2016 | 28.77 | 0 | 128.71 | 128.71 |
12345 | 12/09/2016 | 12/09/2016 | 28.77 | 0 | 157.48 | 157.48 |
54321 | 28/08/2016 | 28/06/2016 | 0.00 | 250 | 250.00 | 250.00 |
54321 | 28/08/2016 | 28/07/2016 | -17.25 | 0 | 232.75 | 232.75 |
54321 | 28/08/2016 | 28/08/2016 | 17.18 | 0 | 249.93 | 249.93 |