What is the highest attendance for the opponents Club Brugge in Venue A?
CREATE TABLE table_name_64 (attendance INTEGER, opponent VARCHAR, venue VARCHAR)
SELECT MAX(attendance) FROM table_name_64 WHERE opponent = "club brugge" AND venue = "a"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (attendance INTEGER, opponent VARCHAR, venue VARCHAR) Question: What is the highest attendance for the opponents Club Brugge in Venue A? [/INST] SELECT MAX(attendance) FROM table_name_64 WHERE opponent = "club brugge" AND venue = "a" </s>