What is the highest season wth a Win of 1 and a Position that is 8th?
CREATE TABLE table_name_3 (season INTEGER, wins VARCHAR, position VARCHAR)
SELECT MAX(season) FROM table_name_3 WHERE wins = 1 AND position = "8th"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_3 (season INTEGER, wins VARCHAR, position VARCHAR) Question: What is the highest season wth a Win of 1 and a Position that is 8th? [/INST] SELECT MAX(season) FROM table_name_3 WHERE wins = 1 AND position = "8th" </s>