By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 2
| value | start_date | end_date |
|---|---|---|
| value1 | 2020-03-09 | 2020-07-09 |
| value2 | 2020-07-09 | 2020-09-20 |
| value1 | 2020-09-20 | 2020-09-26 |
| null | 2020-09-26 | null |
SELECT 4