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

SELECT *
FROM scores;