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
);