Find the number of rooms with more than 50 capacity for each building.
CREATE TABLE classroom (building VARCHAR, capacity INTEGER)
SELECT COUNT(*), building FROM classroom WHERE capacity > 50 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 number of rooms with more than 50 capacity for each building. [/INST] SELECT COUNT(*), building FROM classroom WHERE capacity > 50 GROUP BY building </s>