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