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