update total_scores 
set passed = A.ave < total_score
from (select avg(total_score) as ave from total_scores) as A;
select * from total_scores;