update total_scores
set ranking = a.ranking
from

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

where total_scores.student_code = a.student_code;