update total_scores as a
   set ranking = b.rn
  from (select student_code,
        rank() over(order by total_score desc) as rn
          from total_scores) as b
 where a.student_code = b.student_code