update total_scores
set ranking = sub.rank
from (SELECT student_code,RANK() OVER(ORDER BY total_score DESC) as rank FROM total_scores) as sub
where total_scores.student_code = sub.student_code
;

--select * from total_scores
--order by ranking asc;