UPDATE total_scores AS ts
SET total_score = sub.sum

FROM (
SELECT student_code, sum(score) AS sum,
FROM scores
GROUP BY student_code
) AS sub

WHERE ts.student_code = sub.sudent_code;