By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT 8
| coalesce | switched_on | switched_off |
|---|---|---|
| 1 | 2024-09-01 | 2024-09-03 |
| 1 | 2024-09-04 | 2024-09-07 |
| 2 | 2024-09-02 | 2024-09-05 |
| 3 | 2024-09-06 | null |
| 4 | null | 2024-09-08 |
SELECT 5