Database: dorm_1
Question: How many dorms are there and what is the total capacity for each gender?
SQL:
SELECT count(*) ,  sum(student_capacity) ,  gender FROM dorm GROUP BY gender