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

select *
from total_scores