UPDATE TOTAL_SCORES AS MAIN
SET TOTAL_SCORE = S
FROM (SELECT STUDENT_CODE,SUM(SCORE) AS S FROM SCORES GROUP BY STUDENT_CODE) AS SUB
WHERE SUB.STUDENT_CODE = MAIN.STUDENT_CODE;