update total_scores as a
   set total_score = b.total_score
  from (select student_code,sum(score) as total_score
          from scores
        group by student_code) as b
 where a.student_code = b.student_code