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