UPDATE total_scores 
    SET total_score = SUB.total_score
    FROM    (SELECT
                student_code
                , SUM(score) AS total_score
            FROM scores
            GROUP BY student_code
            ) AS SUB
    WHERE
        total_scores.student_code = SUB.student_code;