UPDATE
    total_scores AS ts
SET 
    total_score = total.sum
FROM(
    SELECT 
        student_code, SUM(score) AS sum
    FROM scores
    GROUP BY student_code
) AS total
WHERE ts.student_code = total.student_code