add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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