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