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