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