By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | Enrollment_Month | Consecutive_Months |
|---|---|---|
| 1 | 202403 | 1 |
| 1 | 202404 | 2 |
| 1 | 202405 | 3 |
| 1 | 202407 | 1 |
| 1 | 202409 | 1 |
| 1 | 202410 | 2 |
| 1 | 202411 | 3 |
| 1 | 202503 | 1 |
| 1 | 202504 | 1 |
| 2 | 202401 | 1 |
| 2 | 202402 | 2 |
| 2 | 202407 | 1 |
| 2 | 202408 | 2 |
| 7 | 202410 | 1 |
| 7 | 202411 | 2 |
| 7 | 202412 | 3 |
| 7 | 202501 | 4 |
| 8 | 202410 | 1 |
| 8 | 202501 | 1 |
| 8 | 202502 | 2 |
| 9 | 202412 | 1 |
| 9 | 202501 | 2 |
| ID | currMonth | prevMonth | dif | seqN | ConsecutiveMonths |
|---|---|---|---|---|---|
| 1 | 202403 | 202403 | 0 | 0 | 1 |
| 1 | 202404 | 202403 | 1 | 0 | 2 |
| 1 | 202405 | 202404 | 1 | 0 | 3 |
| 1 | 202407 | 202405 | 2 | 1 | 1 |
| 1 | 202409 | 202407 | 2 | 2 | 1 |
| 1 | 202410 | 202409 | 1 | 2 | 2 |
| 1 | 202411 | 202410 | 1 | 2 | 3 |
| 1 | 202503 | 202411 | 4 | 3 | 1 |
| 1 | 202504 | 202503 | 1 | 3 | 2 |
| 2 | 202401 | 202401 | 0 | 0 | 1 |
| 2 | 202402 | 202401 | 1 | 0 | 2 |
| 2 | 202407 | 202402 | 5 | 1 | 1 |
| 2 | 202408 | 202407 | 1 | 1 | 2 |
| 7 | 202410 | 202410 | 0 | 0 | 1 |
| 7 | 202411 | 202410 | 1 | 0 | 2 |
| 7 | 202412 | 202411 | 1 | 0 | 3 |
| 7 | 202501 | 202412 | 1 | 0 | 4 |
| 8 | 202410 | 202410 | 0 | 0 | 1 |
| 8 | 202501 | 202410 | 3 | 1 | 1 |
| 8 | 202502 | 202501 | 1 | 1 | 2 |
| 9 | 202412 | 202412 | 0 | 0 | 1 |
| 9 | 202501 | 202412 | 1 | 0 | 2 |
| ID | currMonth | prevMonth | dif | seqN | ConsecutiveMonths |
|---|---|---|---|---|---|
| 1 | 202403 | 202403 | 0 | 0 | 1 |
| 1 | 202404 | 202403 | 1 | 0 | 2 |
| 1 | 202405 | 202404 | 1 | 0 | 3 |
| 1 | 202407 | 202405 | 2 | 1 | 1 |
| 1 | 202409 | 202407 | 2 | 2 | 1 |
| 1 | 202410 | 202409 | 1 | 2 | 2 |
| 1 | 202411 | 202410 | 1 | 2 | 3 |
| 1 | 202503 | 202411 | 4 | 3 | 1 |
| 1 | 202504 | 202503 | 1 | 3 | 2 |
| 2 | 202401 | 202401 | 0 | 0 | 1 |
| 2 | 202402 | 202401 | 1 | 0 | 2 |
| 2 | 202407 | 202402 | 5 | 1 | 1 |
| 2 | 202408 | 202407 | 1 | 1 | 2 |
| 7 | 202410 | 202410 | 0 | 0 | 1 |
| 7 | 202411 | 202410 | 1 | 0 | 2 |
| 7 | 202412 | 202411 | 1 | 0 | 3 |
| 7 | 202501 | 202412 | 1 | 0 | 4 |
| 8 | 202410 | 202410 | 0 | 0 | 1 |
| 8 | 202501 | 202410 | 3 | 1 | 1 |
| 8 | 202502 | 202501 | 1 | 1 | 2 |
| 9 | 202412 | 202412 | 0 | 0 | 1 |
| 9 | 202501 | 202412 | 1 | 0 | 2 |