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