UPDATE total_scores AS TS
SET ranking = SUB.RANKING
FROM (
        SELECT student_code, RANK() OVER(ORDER BY total_score DESC) AS RANKING
        FROM total_scores
    ) AS SUB
WHERE TS.student_code = SUB.student_code;

-- SELECT * FROM total_scores