UPDATE total_scores 
    SET total_score = T.total_score
    FROM ( SELECT 
            student_code, 
            SUM(score) as total_score
        FROM scores
        GROUP BY student_code
    ) AS T
    WHERE total_scores.student_code =  T.student_code
;select * from total_scores