UPDATE total_scores
SET ranking = sub.ran
FROM(
SELECT RANK() OVER(ORDER BY total_score DESC) AS ran
FROM total_scores
) AS sub;