What is the highest attendance for the match against west ham united at the venue of a?
CREATE TABLE table_name_42 (attendance INTEGER, venue VARCHAR, opponent VARCHAR)
SELECT MAX(attendance) FROM table_name_42 WHERE venue = "a" AND opponent = "west ham united"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (attendance INTEGER, venue VARCHAR, opponent VARCHAR) Question: What is the highest attendance for the match against west ham united at the venue of a? [/INST] SELECT MAX(attendance) FROM table_name_42 WHERE venue = "a" AND opponent = "west ham united" </s>