By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| loan_number | daydate | status | daysPastDue |
|---|---|---|---|
| 111111 | 2020-01-01 | Live | 0 |
| 111111 | 2020-01-02 | Live | 0 |
| 111111 | 2020-01-03 | PastDue | 1 |
| 111111 | 2020-01-04 | PastDue | 2 |
| 111111 | 2020-01-05 | Restruct | 0 |
| 111111 | 2020-01-06 | Restruct | 0 |
| 111111 | 2020-01-07 | Restruct | 0 |
| 111111 | 2020-01-08 | PastDue | 1 |
| 111111 | 2020-01-09 | PastDue | 2 |
| 111111 | 2020-01-10 | Closed | 0 |