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