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;