UPDATE total_scores AS  t_s
SET total_score= sub.total
FROM (
 SELECT student_code,SUM(score) AS total
 FROM scores
 GROUP BY student_code
) AS sub
WHERE t_s.student_code = sub.student_code; -- 副問合せ結果との結合条件を指定

SELECT * FROM total_scores;