update total_scores set total_score = (
    select sum(score) from scores as S 
    where total_scores.student_code = S.student_code
    group by student_code 
    )