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