update total_scores as A
set ranking = B.ranking
from
(
select
rank() over(order by total_score desc) as ranking,
student_code
from total_scores
) as B
where A.student_code = B.student_code;

select
    *
from
    total_scores