SELECT count(*) ,  sum(student_capacity) ,  gender FROM dorm GROUP BY gender
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
Find the number of dorms and total capacity for each gender .