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;
-- SELECT * FROM scores