update total_scores
set passed = 
case when total_score >= (select avg(total_score) from total_scores) then TRUE
else FALSE
END;