Which Field goals is the highest one that has Touchdowns of 0, and Points larger than 4?
CREATE TABLE table_name_76 (field_goals INTEGER, touchdowns VARCHAR, points VARCHAR)
SELECT MAX(field_goals) FROM table_name_76 WHERE touchdowns = 0 AND points > 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (field_goals INTEGER, touchdowns VARCHAR, points VARCHAR) Question: Which Field goals is the highest one that has Touchdowns of 0, and Points larger than 4? [/INST] SELECT MAX(field_goals) FROM table_name_76 WHERE touchdowns = 0 AND points > 4 </s>