UPDATE scores AS s1
SET passed = TRUE
WHERE s1.score >= (
    SELECT AVG(score)
    FROM scores AS s2
    WHERE s1.subject_code = s2.subject_code
);
UPDATE scores
SET passed = FALSE
WHERE passed IS NULL;