UPDATE total_scores 
SET passed = 
CASE  WHEN total_score >= sub.ave 
    THEN TRUE
      ELSE FALSE
     END
FROM(
SELECT AVG(total_score) AS ave
    FROM total_scores
) AS sub;