update scores
set passed = case when score >= sub.avg then true else false end
from 
(select subject_code,
avg(score) avg
from scores
group by subject_code) sub
WHERE s.subject_code = sub.subject_code