Schema: CREATE TABLE building (floors INTEGER)
Question: What are the average, maximum, and minimum number of floors for all buildings?
SQL: SELECT AVG(floors), MAX(floors), MIN(floors) FROM building