UPDATE	scores			
SET		passed = 1		
FROM	(			
		SELECT	subject_code,
				AVG(score) AS avg
		FROM scores
		GROUP BY subject_code
		) AS sub		
		INNER JOIN scores AS sc
			ON sc.subject_code = sub.subject_code
WHERE	sc.subject_code = sub.subject_code
    	AND sc.score >= sub.avg;
				
UPDATE	scores			
SET		passed = 0		
WHERE	passed IS NULL;