I want to know the average attendance for n venue and f round
CREATE TABLE table_name_49 (attendance INTEGER, venue VARCHAR, round VARCHAR)
SELECT AVG(attendance) FROM table_name_49 WHERE venue = "n" AND round = "f"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_49 (attendance INTEGER, venue VARCHAR, round VARCHAR) Question: I want to know the average attendance for n venue and f round [/INST] SELECT AVG(attendance) FROM table_name_49 WHERE venue = "n" AND round = "f" </s>