UPDATE
    scores
SET
    passed = case when(score >= sub.avg)then true
    else
        false
    end
from
    (select 
        AVG(score)as avg
    from
        scores
    group by subject_code
    ) as sub;