UPDATE scores
SET passed = TRUE
FROM (
SELECT subject_code
    ,AVG(score) AS avg
FROM scores
GROUP BY subject_code
) AS sub
WHERE scores.subject_code = sub.subject_code
    AND scores.score >= sub.avg;
--
UPDATE scores
SET passed = FALSE
WHERE passed IS NULL;