By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Account_Number | Interest_Rate | LastDateOfMonth | Capital_Balance_Calculated | Interest | Payment |
|---|---|---|---|---|---|
| 12345 | 4.29 | 2019-03-31 | 100 | 5 | 7 |
| 12345 | 4.29 | 2019-04-30 | 0 | null | 7 |
| 12345 | 4.29 | 2019-05-31 | 0 | null | 5 |
| 12345 | 4.29 | 2019-06-30 | 0 | null | 7 |
| 12345 | 4.29 | 2019-07-31 | 0 | null | 7 |
| 54321 | 5.14 | 2019-03-31 | 200 | 6 | 8 |
| 54321 | 5.14 | 2019-04-30 | 0 | null | 6 |
| 54321 | 5.14 | 2019-05-31 | 0 | null | 8 |
| 54321 | 5.14 | 2019-06-30 | 0 | null | 10 |
| 54321 | 5.14 | 2019-07-31 | 0 | null | 8 |
| Account_Number | Interest_Rate | LastDateOfMonth | Capital_Balance_Calculated | Interest | Payment |
|---|---|---|---|---|---|
| 12345 | 4.29 | 2019-03-31 | 100 | 5 | 7 |
| 12345 | 4.29 | 2019-04-30 | 97.29 | 4.29 | 7 |
| 12345 | 4.29 | 2019-05-31 | 94.463741 | 4.173741 | 5 |
| 12345 | 4.29 | 2019-06-30 | 93.5162354889 | 4.0524944889 | 7 |
| 12345 | 4.29 | 2019-07-31 | 90.5280819913738 | 4.01184650247381 | 7 |
| 54321 | 5.14 | 2019-03-31 | 200 | 6 | 8 |
| 54321 | 5.14 | 2019-04-30 | 202.28 | 10.28 | 6 |
| 54321 | 5.14 | 2019-05-31 | 206.677192 | 10.397192 | 8 |
| 54321 | 5.14 | 2019-06-30 | 209.3003996688 | 10.6232076688 | 10 |
| 54321 | 5.14 | 2019-07-31 | 210.058440211776 | 10.7580405429763 | 8 |