WITH T AS(
    SELECT
        student_code,
        RANK() OVER(ORDER BY total_score DESC) AS rank
    FROM
        total_scores
)
UPDATE
    total_scores
SET
    ranking = T.rank
FROM
    T
WHERE
    total_scores.student_code = T.student_code