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