update total_scores as ts
set ranking = t.ranking
from (
    select student_code,
        rank() over(order by total_score desc) ranking
    from total_scores
    ) t
where t.student_code = ts.student_code;