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