UPDATE total_scores AS ts
SET total_score = s.total_score
FROM (SELECT student_code, SUM(score) AS total_score
FROM scores GROUP BY student_code) AS s
WHERE ts.student_code = s.student_code