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

UPDATE
	scores AS s
SET
	passed = FALSE
WHERE
	passed = NULL;