UPDATE scores AS S
SET passed = TRUE
FROM (
    SELECT 
        subject_code,
        AVG(score) AS AVG
    FROM scores
    GROUP BY student_code
) AS SUB
WHERE S.subject_code = SUB.subject_code
    AND S.score >= SUB.AVG;


UPDATE scores
SET passed = FALSE
WHERE passed IS NULL;

-- SELECT * FROM scores