By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| ROAD_ID | YEAR | COND |
|---|---|---|
| 1 | 2009 | 17 |
| 1 | 2010 | 17 |
| 1 | 2011 | 16 |
| 1 | 2012 | 16 |
| 1 | 2013 | 16 |
| 1 | 2014 | 16 |
| 1 | 2015 | 14 |
| 1 | 2016 | 18.3 |
| 1 | 2017 | 18.3 |
| 1 | 2018 | 18.3 |
| 1 | 2019 | 18.1 |
| 1 | 2020 | 18.1 |
| 1 | 2021 | 18.1 |
| 1 | 2022 | 18.1 |
| 1 | 2023 | 18.1 |
| 2 | 2013 | 17.5 |
| 2 | 2014 | 17.5 |
| 2 | 2015 | 17.5 |
| 2 | 2016 | 18 |
| 2 | 2017 | 18 |
| 2 | 2018 | 18 |
| 2 | 2019 | 18 |
| 2 | 2020 | 18 |
| 2 | 2021 | 18 |
| 2 | 2022 | 18 |
| 2 | 2023 | 18 |
| 3 | 2022 | 20 |
| 3 | 2023 | 20 |