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;