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;