Database: dorm_1
Question: Find the number of dorms and total capacity for each gender.
SQL:
SELECT count(*) ,  sum(student_capacity) ,  gender FROM dorm GROUP BY gender