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