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