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

select * from total_scores