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