update total_scores as t
set t.total_score = sub.sum
from (
  select
    student_code
    , sum(score) as sum
  from
    scores
  group by
    student_code
) as sub
where
  t.student_code = sub.student_code
;