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)
;
select * from total_scores;