UPDATE total_scores
SET ranking = sub.rank
FROM(
    SELECT total_score, RANK() OVER(ORDER BY total_score DESC) AS rank
    FROM total_scores
    GROUP BY total_score
)AS sub
WHERE total_scores.total_score = sub.total_score;

SELECT * FROM total_scores;