What is the highest wins for the NFL with a finish of 1st, and more than 6 losses?
CREATE TABLE table_name_27 (wins INTEGER, losses VARCHAR, league VARCHAR, finish VARCHAR)
SELECT MAX(wins) FROM table_name_27 WHERE league = "nfl" AND finish = "1st" AND losses > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (wins INTEGER, losses VARCHAR, league VARCHAR, finish VARCHAR) Question: What is the highest wins for the NFL with a finish of 1st, and more than 6 losses? [/INST] SELECT MAX(wins) FROM table_name_27 WHERE league = "nfl" AND finish = "1st" AND losses > 6 </s>