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

SELECT * FROM total_scores ORDER BY ranking ASC;