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 ;