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