update total_scores
set ranking = sub1.total_rank
from (select rank() over(order by total_score) as total_rank from total_scores) as sub1;