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 ;