--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) as avg from total_scores);

update total_scores
set passed = case when total_score >= (select avg(total_score) from total_scores) then true
    else false
    end;

select * from total_scores