UPDATE total_scores
SET passed = CASE
WHEN total_score >= (select AVG(total_score) from total_scores where test_code = 'T00001')
THEN 1
ELSE 0
END;