UPDATE scores AS s1
SET passed =
    CASE 
    WHEN s1.score >= (
        SELECT AVG(score)
        FROM scores AS s2
        WHERE s1.subject_code = s2.subject_code
    ) THEN TRUE
    ELSE FALSE
    END