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