UPDATE total_scores
SET passed = 'TRUE'
WHERE total_score >= (select avg(total_score) from total_scores );

UPDATE total_scores
SET passed = 'FALSE'
WHERE total_score <= (select avg(total_score) from total_scores );