UPDATE scores AS scr
SET
    passed = CASE
        WHEN score >= sub.ave THEN TRUE
        ELSE FALSE
    END
FROM
(
    SELECT
        subject_code
        , AVG(score) AS ave
    FROM scores
    GROUP BY subject_code
) AS sub
WHERE scr.subject_code = sub.subject_code;