with SubScores as (
    select student_code, sum(score) as total_score
    from scores
    group by student_code
)

update total_scores as ts
set total_score = sub.total_score
from SubScores as sub
where ts.student_code = sub.student_code
;

select * from total_scores