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