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