update total_scores as a
set total_score = sum_score
from
(
    select
        student_code
        ,sum(score) sum_score
    from
        scores
    group by
        student_code
) as tmp
where
    a.student_code = tmp.student_code
;
select * from total_scores;