UPDATE scores as s
SET passed = 
CASE 
	WHEN score >= sub.avg THEN TRUE
	ELSE FALSE END
from(select subject_code,avg(score) as avg from scores group by subject_code) sub
where s.subject_code = sub.subject_code