update total_scores
set ranking = t.ranking
from (

    SELECT 
        student_code
        ,RANK() OVER(ORDER BY total_score DESC) as ranking
    FROM 
        total_scores
) as t
where total_scores.student_code = t.student_code;

select * from total_scores