update total_scores
set ranking = tmp.r
from (select student_code, rank() over(order by total_score DESC) as r from total_scores) as tmp
where total_scores.student_code = tmp.student_code;

--select * from total_scores;