For a goal difference greater than 3 and fewer than 8 losses, what is the most draws scored?
CREATE TABLE table_name_94 (draws INTEGER, goal_difference VARCHAR, losses VARCHAR)
SELECT MAX(draws) FROM table_name_94 WHERE goal_difference > 3 AND losses < 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_94 (draws INTEGER, goal_difference VARCHAR, losses VARCHAR) Question: For a goal difference greater than 3 and fewer than 8 losses, what is the most draws scored? [/INST] SELECT MAX(draws) FROM table_name_94 WHERE goal_difference > 3 AND losses < 8 </s>