What is the highest number of losses that a team who had an away record of 1-6 and more than 4 wins had?
CREATE TABLE table_name_6 (losses INTEGER, away VARCHAR, wins VARCHAR)
SELECT MAX(losses) FROM table_name_6 WHERE away = "1-6" AND wins > 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (losses INTEGER, away VARCHAR, wins VARCHAR) Question: What is the highest number of losses that a team who had an away record of 1-6 and more than 4 wins had? [/INST] SELECT MAX(losses) FROM table_name_6 WHERE away = "1-6" AND wins > 4 </s>