Could you give me the number of dorms for each gender?
select count ( * ), gender from dorm group by gender
What are the names of those dorms?
select dorm_name from dorm
What is the dorm name of the dorm with the smallest capacity?
select dorm_name from dorm order by student_capacity desc limit 1