UPDATE scores
SET passed =
    CASE
    WHEN score > sub.ave
    THEN TRUE
    ELSE FALSE
    END
FROM(SELECT AVG(score) AS ave
FROM scores
GROUP BY subject_code--各科目の平均点
) AS sub
WHERE scores.subject_code = sub.subject_code;