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