By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | start_date | end_date | DateGroup |
|---|---|---|---|
| 1 | 2023-01-01 | 2024-01-01 | 1 |
| 1 | 2023-05-01 | 2024-07-01 | 1 |
| 1 | 2024-05-01 | 2024-07-01 | 1 |
| 1 | 2024-08-01 | 2024-09-01 | 2 |
| 1 | 2025-01-01 | 2026-01-01 | 3 |
| 1 | 2026-05-01 | 2026-07-01 | 4 |