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