update total_scores as ts
set total_score = T.score
from (select student_code,sum(score) as score from scores group by student_code) as T
where T.student_code = ts.student_code