Find the average and total capacity of dorms for the students with gender X.
CREATE TABLE dorm (student_capacity INTEGER, gender VARCHAR)
SELECT AVG(student_capacity), SUM(student_capacity) FROM dorm WHERE gender = 'X'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE dorm (student_capacity INTEGER, gender VARCHAR) Question: Find the average and total capacity of dorms for the students with gender X. [/INST] SELECT AVG(student_capacity), SUM(student_capacity) FROM dorm WHERE gender = 'X' </s>