By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | start | end | cancelled |
|---|---|---|---|
| 1 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-01-10 00:00:00 |
| 2 | 2021-02-01 00:00:00 | 2022-01-31 00:00:00 | null |
| 2 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | null |
| 3 | 2020-01-01 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 |
| 3 | 2020-07-10 00:00:00 | 2021-01-09 00:00:00 | 2021-01-31 00:00:00 |
| 3 | 2021-02-02 00:00:00 | 2021-08-01 00:00:00 | null |
| id | end | next_start | gap |
|---|---|---|---|
| 2 | 2020-12-31 00:00:00 | 2021-02-01 00:00:00 | 32 |
| 3 | 2020-07-01 00:00:00 | 2020-07-10 00:00:00 | 9 |
| 3 | 2021-01-31 00:00:00 | 2021-02-02 00:00:00 | 2 |