By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ROAD_ID | YEAR | COND |
|---|---|---|
| 1 | 2009 | 17 |
| 1 | 2011 | 16 |
| 1 | 2015 | 14 |
| 1 | 2016 | 18.3 |
| 1 | 2019 | 18.1 |
| 2 | 2013 | 17.5 |
| 2 | 2016 | 18 |
| 2 | 2019 | 18 |
| 2 | 2022 | 18 |
| 3 | 2022 | 20 |
| ROAD_ID | YEAR | COND |
|---|---|---|
| 1 | 2009 | 17 |
| 1 | 2011 | 16 |
| 1 | 2015 | 14 |
| 1 | 2016 | 18.3 |
| 1 | 2019 | 18.1 |
| 2 | 2013 | 17.5 |
| 2 | 2016 | 18 |
| 2 | 2019 | 18 |
| 2 | 2022 | 18 |
| 3 | 2022 | 20 |