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