find the total number of dorms.
select count(*) from dorm
what is the total student capacity of all dorms?
select sum(student_capacity) from dorm
how about for each gender?
select sum(student_capacity), gender from dorm group by gender
also show the number of dorms for each gender.
select count(*), sum(student_capacity), gender from dorm group by gender