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