with t1 as(select subject_code,avg(score) me from scores where test_code='T00001' group by subject_code)

update scores set passed=t1.me <=scores.score
from t1
where t1.subject_code=scores.subject_code
and scores.test_code='T00001';