How many tournament titles for texas with over 0 total?
CREATE TABLE table_name_89 (tournament VARCHAR, total VARCHAR, team VARCHAR)
SELECT COUNT(tournament) FROM table_name_89 WHERE total > 0 AND team = "texas"
### Context: CREATE TABLE table_name_89 (tournament VARCHAR, total VARCHAR, team VARCHAR) ### Question: How many tournament titles for texas with over 0 total? ### Answer: SELECT COUNT(tournament) FROM table_name_89 WHERE total > 0 AND team = "texas"