What's the average number of floors that were built in 2004, and have a roof (m) of 106?
CREATE TABLE table_name_67 (floors INTEGER, built VARCHAR, roof___m__ VARCHAR)
SELECT AVG(floors) FROM table_name_67 WHERE built = 2004 AND roof___m__ = 106
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_67 (floors INTEGER, built VARCHAR, roof___m__ VARCHAR) Question: What's the average number of floors that were built in 2004, and have a roof (m) of 106? [/INST] SELECT AVG(floors) FROM table_name_67 WHERE built = 2004 AND roof___m__ = 106 </s>