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