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
### Context: CREATE TABLE dorm (gender VARCHAR, student_capacity INTEGER) ### Question: Find the number of dorms and total capacity for each gender. ### Answer: SELECT COUNT(*), SUM(student_capacity), gender FROM dorm GROUP BY gender