What is the average capacity of the stadiums that were opened in year 2005?
CREATE TABLE stadium (capacity INTEGER, opening_year VARCHAR)
SELECT AVG(capacity) FROM stadium WHERE opening_year = 2005
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE stadium (capacity INTEGER, opening_year VARCHAR) Question: What is the average capacity of the stadiums that were opened in year 2005? [/INST] SELECT AVG(capacity) FROM stadium WHERE opening_year = 2005 </s>