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