UPDATE total_scores
  SET
    passed = 
    CASE
      WHEN total_score < (SELECT AVG(total_score) FROM total_scores) THEN false
      ELSE true
    END;