UPDATE total_scores
SET total_score = sub.SCO
FROM (SELECT  STUDENT_CODE,SUM(SCORE) AS SCO FROM SCORES GROUP BY STUDENT_CODE) AS sub
WHERE total_scores.STUDENT_CODE = sub.STUDENT_CODE ;