By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | rate | year | rank |
---|---|---|---|
p01 | 8.0 | 2006 | 0 |
p01 | 7.4 | 2003 | 1 |
p01 | 6.8 | 2008 | 2 |
p01 | 5.9 | 2001 | 3 |
p01 | 5.3 | 2007 | 4 |
p02 | 12.5 | 2001 | 0 |
p02 | 12.4 | 2004 | 1 |
p02 | 12.2 | 2002 | 2 |
p02 | 10.3 | 2003 | 3 |
p02 | 8.7 | 2000 | 4 |