UPDATE scores
SET passed = CASE WHEN scores.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 scores.subject_code = sub.subject_code