CREATE TABLE dorm (gender VARCHAR(255), student_capacity INTEGER)
Find the number of dorms and total capacity for each gender.
    
SQL: SELECT COUNT(*), SUM(student_capacity), gender FROM dorm GROUP BY gender