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