How many wins were there for Washington State College with losses greater than 980 and a first season before 1906 and rank greater than 42?
CREATE TABLE table_name_29 (wins VARCHAR, rank VARCHAR, college VARCHAR, losses VARCHAR, first_season VARCHAR)
SELECT COUNT(wins) FROM table_name_29 WHERE losses > 980 AND first_season < 1906 AND college = "washington state" AND rank > 42
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (wins VARCHAR, rank VARCHAR, college VARCHAR, losses VARCHAR, first_season VARCHAR) Question: How many wins were there for Washington State College with losses greater than 980 and a first season before 1906 and rank greater than 42? [/INST] SELECT COUNT(wins) FROM table_name_29 WHERE losses > 980 AND first_season < 1906 AND college = "washington state" AND rank > 42 </s>