UPDATE
	scores AS s
SET
	passed = TRUE
FROM(
	SELECT
		subject_code
		,AVG(score) AS avg
	FROM
		scores
	GROUP BY
		subject_code
) AS sub
WHERE sub.subject_code = s.subject_code
	AND s.score >= sub.avg;

UPDATE
	scores
SET
	passed = FALSE
WHERE
	passed IS NULL;