By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| identifier | start_date | end_date |
|---|---|---|
| 4EF | 2021-07-29 | 2021-08-03 |
| 4EF | 2021-08-06 | 2021-08-12 |
| 4EF | 2021-10-07 | 2021-11-12 |
| 4EF | 2021-11-15 | 2021-11-30 |
SELECT 4
| identifier | start_date | end_date |
|---|---|---|
| 4EF | 2021-07-29 | 2021-08-03 |
| 4EF | 2021-08-06 | 2021-08-12 |
| 4EF | 2021-10-07 | 2021-11-12 |
| 4EF | 2021-11-15 | 2021-11-30 |
SELECT 4