By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
MEM_ID | CLM_ID | ADM_DT | DCHG_DT | GROUP_ID |
---|---|---|---|---|
1 | 111 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 1 |
1 | 112 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2 |
1 | 113 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2 |
1 | 114 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 3 |
2 | 211 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 1 |
2 | 212 | 2020-05-01 00:00:00 | 2020-08-01 00:00:00 | 2 |
3 | 311 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 1 |
3 | 312 | 2020-03-01 00:00:00 | 2020-05-01 00:00:00 | 1 |
3 | 313 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 1 |
3 | 314 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2 |