What was the result for the 1966 fifa world cup qualification in mexico city, mexico and a goal over 8?
CREATE TABLE table_name_41 (result VARCHAR, goal VARCHAR, venue VARCHAR, competition VARCHAR)
SELECT result FROM table_name_41 WHERE venue = "mexico city, mexico" AND competition = "1966 fifa world cup qualification" AND goal > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_41 (result VARCHAR, goal VARCHAR, venue VARCHAR, competition VARCHAR) Question: What was the result for the 1966 fifa world cup qualification in mexico city, mexico and a goal over 8? [/INST] SELECT result FROM table_name_41 WHERE venue = "mexico city, mexico" AND competition = "1966 fifa world cup qualification" AND goal > 8 </s>