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
;