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