How many Attendances have a Result F – A of 0 – 2, and a Date of 31 january 1903?
CREATE TABLE table_name_71 (attendance INTEGER, result_f___a VARCHAR, date VARCHAR)
SELECT AVG(attendance) FROM table_name_71 WHERE result_f___a = "0 – 2" AND date = "31 january 1903"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_71 (attendance INTEGER, result_f___a VARCHAR, date VARCHAR) Question: How many Attendances have a Result F – A of 0 – 2, and a Date of 31 january 1903? [/INST] SELECT AVG(attendance) FROM table_name_71 WHERE result_f___a = "0 – 2" AND date = "31 january 1903" </s>