select score , dense_rank() over ( order by score desc ) as "rank" from Scores

Use this code it will work we need to write rank as "rank" because rank is a funcion that's why it's giving error