By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | cyear | va |
---|---|---|
1 | 2018 | 31.000000 |
1 | 2019 | 31.000000 |
1 | 2020 | 31.000000 |
2 | 2017 | 16.666667 |
2 | 2015 | 16.666667 |
2 | 2016 | 16.666667 |
3 | 2010 | 24.833333 |
3 | 2011 | 24.833333 |
3 | 2012 | 24.833333 |