UPDATE
	total_scores
SET
	passed = 
	CASE 
	WHEN total_score >= sub.ave THEM TRUE
	ELSE FALSE END
FROM (
	SELECT AVG(total_score) AS ave
	FROM total_scores
) AS sub;