update total_scores  as ts
set passed = case 
                when total_score >= av.score then true
                else false
            end
from(
    select
        avg(total_score) as score
    from total_scores
) as av
where 1=1