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