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