Name the average attendance with result of won 2-0 on 2 november 2007
CREATE TABLE table_name_82 (attendance__away_ INTEGER, result VARCHAR, date VARCHAR)
SELECT AVG(attendance__away_) FROM table_name_82 WHERE result = "won 2-0" AND date = "2 november 2007"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_82 (attendance__away_ INTEGER, result VARCHAR, date VARCHAR) Question: Name the average attendance with result of won 2-0 on 2 november 2007 [/INST] SELECT AVG(attendance__away_) FROM table_name_82 WHERE result = "won 2-0" AND date = "2 november 2007" </s>