UPDATE
    total_scores
SET
    ranking = (
        SELECT
            RANK() OVER(ORDER BY total_score DESC)
        FROM
            total_scores);
SELECT
    *
FROM
    total_scores;