update scores
set passed = case when 
    score >= (select avg(score) from scores group by subject_code) then true
    else false
    end