update total_scores
set total_score = t.total_score
from (select test_code,
    student_code,
    sum(score) total_score
    from scores
    group by test_code, student_code
    ) t
where t.test_code = total_scores.test_code
and t.student_code = total_scores.student_code;