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 |