How many were in attendance for a result of D, at H venue, and Arsenal as an opponent?
CREATE TABLE table_name_40 (attendance VARCHAR, opponents VARCHAR, result VARCHAR, venue VARCHAR)
SELECT attendance FROM table_name_40 WHERE result = "d" AND venue = "h" AND opponents = "arsenal"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (attendance VARCHAR, opponents VARCHAR, result VARCHAR, venue VARCHAR) Question: How many were in attendance for a result of D, at H venue, and Arsenal as an opponent? [/INST] SELECT attendance FROM table_name_40 WHERE result = "d" AND venue = "h" AND opponents = "arsenal" </s>