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;