UPDATE scores as sc
SET passed = TRUE
FROM(
SELECT subject_code,AVG(score) as b
FROM scores
GROUP BY subject_code
) as sub
Where sc.subject_code = sub.subject_code
AND sc.score >= sub.b;

UPDATE  scores as sc
SET passed = FALSE
WHERE  passed IS NULL