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