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;