How many seasons have 1 goals and more than 11 apps?
CREATE TABLE table_name_89 (season VARCHAR, goals VARCHAR, apps VARCHAR)
SELECT COUNT(season) FROM table_name_89 WHERE goals = 1 AND apps > 11
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_89 (season VARCHAR, goals VARCHAR, apps VARCHAR) Question: How many seasons have 1 goals and more than 11 apps? [/INST] SELECT COUNT(season) FROM table_name_89 WHERE goals = 1 AND apps > 11 </s>