Find the maximum and average capacity among rooms in each building.
CREATE TABLE classroom (building VARCHAR, capacity INTEGER)
SELECT MAX(capacity), AVG(capacity), building FROM classroom GROUP BY building
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE classroom (building VARCHAR, capacity INTEGER) Question: Find the maximum and average capacity among rooms in each building. [/INST] SELECT MAX(capacity), AVG(capacity), building FROM classroom GROUP BY building </s>