By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| FirstDayOfMonth | OccupancyID | CustomerVoice_RepairsSatisfactionFeedbackID | RowNumber |
|---|---|---|---|
| 2023-10-01 | 3313 | null | 1 |
| 2023-11-01 | 3313 | 150015 | 2 |
| 2023-12-01 | 3313 | null | 3 |
| 2024-01-01 | 3313 | 100812 | 4 |
| 2024-02-01 | 3313 | null | 5 |
| 2024-03-01 | 3313 | null | 6 |
| 2023-10-01 | 182 | null | 1 |
| 2023-11-01 | 182 | 100571 | 2 |
| 2023-12-01 | 182 | null | 3 |
| 2024-01-01 | 182 | null | 4 |
| 2024-02-01 | 182 | null | 5 |
| 2024-03-01 | 182 | null | 6 |
| OccupancyID | FirstDayOfMonth | CustomerVoice_RepairsSatisfactionFeedbackID | PreviousNonNULLCustomerVoice_RepairsSatisfactionFeedbackID |
|---|---|---|---|
| 182 | 2023-10-01 | null | null |
| 182 | 2023-11-01 | 100571 | null |
| 182 | 2023-12-01 | null | 100571 |
| 182 | 2024-01-01 | null | 100571 |
| 182 | 2024-02-01 | null | 100571 |
| 182 | 2024-03-01 | null | 100571 |
| 3313 | 2023-10-01 | null | null |
| 3313 | 2023-11-01 | 150015 | null |
| 3313 | 2023-12-01 | null | 150015 |
| 3313 | 2024-01-01 | 100812 | 150015 |
| 3313 | 2024-02-01 | null | 100812 |
| 3313 | 2024-03-01 | null | 100812 |