update scores as s
set passed = 1
from (select subject_code, avg(score) as avg
from scores
group by subject_code) as sub
where s.subject_code = sub.subject_code
and   s.score >= sub.avg;

update scores
set passed = 0
where passed is null;