update scores
set passed = false;

update scores as s
set passed = true
from (
    select subject_code,
        avg(score) avg_score
    from scores
    group by subject_code
    ) t
where t.subject_code = s.subject_code
and t.avg_score <= s.score;