For Getafe CF, what is the highest number of goals scored?
CREATE TABLE table_name_74 (goals INTEGER, team VARCHAR)
SELECT MAX(goals) FROM table_name_74 WHERE team = "getafe cf"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (goals INTEGER, team VARCHAR) Question: For Getafe CF, what is the highest number of goals scored? [/INST] SELECT MAX(goals) FROM table_name_74 WHERE team = "getafe cf" </s>