UPDATE scores SET passed = TRUE
FROM(
SELECT subject_code, avg(score) avg_s FROM scores
GROUP BY subject_code) t2
WHERE scores.subject_code = t2.subject_code
AND score >= avg_s;

UPDATE scores SET passed = FALSE
WHERE passed is null