update scores as s
set passed = case
                when score >= av.s then true
                else false
            end
from(
    select
        subject_code
        ,avg(score) as s
    from scores
    group by subject_code
) as av
where av.subject_code = s.subject_code