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

UPDATE
    total_scores
SET
    total_score = tb_total.score
FROM
    tb_total
WHERE
    total_scores.student_code = tb_total.student_code;