What is the highest Goals For, when Team is "Cheadle Town", and when Drawn is greater than 7?
CREATE TABLE table_name_2 (goals_for INTEGER, team VARCHAR, drawn VARCHAR)
SELECT MAX(goals_for) FROM table_name_2 WHERE team = "cheadle town" AND drawn > 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (goals_for INTEGER, team VARCHAR, drawn VARCHAR) Question: What is the highest Goals For, when Team is "Cheadle Town", and when Drawn is greater than 7? [/INST] SELECT MAX(goals_for) FROM table_name_2 WHERE team = "cheadle town" AND drawn > 7 </s>