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;