WITH SUMscore AS (
    SELECT
        student_code
        ,SUM(score) AS sumscore
    FROM
        scores
    GROUP BY
        student_code)

UPDATE
    total_scores
SET
    total_score = SUMscore.sumscore
FROM
    SUMscore
WHERE
    total_scores.student_code = SUMscore.student_code;