WITH T AS(
    SELECT
        student_code,
        SUM(score) AS score_sum
    FROM
        scores
    GROUP BY
        student_code
)
UPDATE
    total_scores
SET
    total_score = score_sum
FROM
    T
WHERE
    T.student_code = total_scores.student_code