update scores as s
set passed=TRUE
from (
        select
            subject_code
            , avg(score) as avg
        from scores
        group by subject_code
        ) as sub
where s.subject_code=sub.subject_code and s.score>=sub.avg;

update scores
set passed=FALSE where passed is null;