UPDATE scores AS s
SET passed = TRUE
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 = FALSE
WHERE passed IS NULL;