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

--select CAST(AVG(total_score) AS INT) from total_scores where test_code = 'T00001' GROUP BY test_code;

--select * from total_scores;