By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| PROJ_ID | ROAD_ID | YEAR_ | STATUS | FROM_MEASURE | TO_MEASURE |
|---|---|---|---|---|---|
| 100 | 1 | 2022 | APPROVED | null | 100.1 |
| 101 | 1 | 2022 | APPROVED | 0 | 100.1 |
| 102 | 1 | 2022 | APPROVED | 0 | 200.6 |
| 103 | 1 | 2022 | APPROVED | 0 | 199.3 |
| 104 | 1 | 2022 | APPROVED | 0 | 201 |
| 105 | 2 | 2023 | PROPOSED | 0 | 50 |
| 106 | 2 | 2023 | PROPOSED | 75 | 100 |
| 107 | 3 | 2024 | DEFERRED | 0 | 100 |
| 108 | 3 | 2025 | DEFERRED | 0 | 110 |
| 109 | 4 | 2026 | PROPOSED | 0 | null |
| 110 | 4 | 2026 | DEFERRED | 0 | null |