UPDATE total_scores AS ts
SET total_score = (
    SELECT SUM(score)
    FROM scores AS s
    WHERE ts.student_code = s.student_code
)