What was the highest number of goals for a game held at Hannover?
CREATE TABLE table_name_27 (goal INTEGER, venue VARCHAR)
SELECT MAX(goal) FROM table_name_27 WHERE venue = "hannover"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (goal INTEGER, venue VARCHAR) Question: What was the highest number of goals for a game held at Hannover? [/INST] SELECT MAX(goal) FROM table_name_27 WHERE venue = "hannover" </s>