UPDATE total_scores as ts
SET total_score = sub.sum_score
FROM (select student_code,sum(score) as sum_score 
    from scores
    where test_code = 'T00001'
    group by student_code) AS sub
WHERE ts.student_code = sub.student_code
AND test_code = 'T00001';