SELECT count(*) ,  sum(student_capacity) ,  gender FROM dorm GROUP BY gender
How many dorms are there and what is the 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
How many dorms are there and what is the total capacity for each gender ?