update scores as a
   set passed = (score >= (select avg(b.score)
                             from scores b
                            where b.subject_code = a.subject_code))