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