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;
select * from total_scores