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