update scores
set passed = true
from (
select subject_code,avg(score) as b from scores
group by subject_code) as a
where  scores.subject_code = a.subject_code and
score >= a.b;


update scores
set passed = False
where passed is null;