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