update total_scores as ts
set passed = case
                when total_score >= sub.avg then TRUE
                else FALSE
              end
from (
  select
    avg(total_score) as avg
  from total_scores
) as sub
;