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;