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;