UPDATE total_scores
SET total_score = sub.sum from (select student_code,sum(score) as sum from scores group by student_code) as sub
WHERE total_scores.student_code = sub.student_code;