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