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