What are the average, maximum, and minimum number of floors for all buildings?
CREATE TABLE building (floors INTEGER)
SELECT AVG(floors), MAX(floors), MIN(floors) FROM building
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE building (floors INTEGER) Question: What are the average, maximum, and minimum number of floors for all buildings? [/INST] SELECT AVG(floors), MAX(floors), MIN(floors) FROM building </s>