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