UPDATE total_scores
SET total_score = 0
FROM scores AS sub
WHERE sub.student_code = total_scores.student_code;

UPDATE total_scores
SET total_score = total_score + SCORE
FROM scores AS sub
WHERE SUB.student_code = total_scores.student_code;

SELECT * FROM TOTAL_SCORES;
    
--得点テーブルの得点をもとに各学生の合計得点を集計し、合計得点テーブルの合計得点の値を更新