SELECT 
student_code,
RANK() OVER(ORDER BY total_score DESC) AS ranking
FROM total_scores;

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;