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