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