UPDATE total_scores AS TS
SET passed = 'TRUE'
WHERE TS.total_score >= (SELECT AVG(total_score) FROM total_scores);

UPDATE total_scores AS TS
SET passed = 'FALSE'
WHERE TS.total_score < (SELECT AVG(total_score) FROM total_scores);