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