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