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"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_89 (tournament VARCHAR, total VARCHAR, team VARCHAR) Question: How many tournament titles for texas with over 0 total? [/INST] SELECT COUNT(tournament) FROM table_name_89 WHERE total > 0 AND team = "texas" </s>