CREATE TABLE table_name_27 (goal NUMBER, venue VARCHAR2)

What was the highest number of goals for a game held at Hannover?
SELECT MAX(goal) FROM table_name_27 WHERE venue = "hannover"
SELECT MAX("goal") FROM "table_name_27" WHERE "hannover" = "venue"