For all games with calgary as home, what is the average number of attendees?
CREATE TABLE table_name_1 (attendance INTEGER, home VARCHAR)
SELECT AVG(attendance) FROM table_name_1 WHERE home = "calgary"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (attendance INTEGER, home VARCHAR) Question: For all games with calgary as home, what is the average number of attendees? [/INST] SELECT AVG(attendance) FROM table_name_1 WHERE home = "calgary" </s>