UPDATE SCORES AS SC
SET PASSED = TRUE
FROM (SELECT SUBJECT_CODE,AVG(SCORE) AS AVG FROM SCORES GROUP BY SUBJECT_CODE) AS SUB
WHERE SC.SUBJECT_CODE = SUB.SUBJECT_CODE AND SC.SCORE >= SUB.AVG;

UPDATE SCORES
SET PASSED = FALSE
WHERE PASSED IS NULL;