Find the number of dorms and total capacity for each gender.
SELECT count(*) ,  sum(student_capacity) ,  gender FROM dorm GROUP BY gender
SELECT count(*) ,  sum(student_capacity) ,  gender FROM dorm GROUP BY gender
[{'count(*)': 1, 'sum(student_capacity)': 128, 'gender': 'F'}, {'count(*)': 1, 'sum(student_capacity)': 116, 'gender': 'M'}, {'count(*)': 5, 'sum(student_capacity)': 1136, 'gender': 'X'}]