Find the number of dorms and total capacity for each gender.
CREATE TABLE dorm (gender VARCHAR, student_capacity INTEGER)
SELECT COUNT(*), SUM(student_capacity), gender FROM dorm GROUP BY gender
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE dorm (gender VARCHAR, student_capacity INTEGER) Question: Find the number of dorms and total capacity for each gender. [/INST] SELECT COUNT(*), SUM(student_capacity), gender FROM dorm GROUP BY gender </s>