What is the largest Goals For by a team that has more than 0 ties?
CREATE TABLE table_name_18 (goals_for INTEGER, ties INTEGER)
SELECT MAX(goals_for) FROM table_name_18 WHERE ties > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (goals_for INTEGER, ties INTEGER) Question: What is the largest Goals For by a team that has more than 0 ties? [/INST] SELECT MAX(goals_for) FROM table_name_18 WHERE ties > 0 </s>