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