Find the name and gender type of all dorms.
select dorm_name, gender from dorm
which of them have a capacity greater than 300?
select dorm_name, gender from dorm where student_capacity > 300
also show the dorms with a capacity less than 100.
select dorm_name, gender from dorm where student_capacity > 300 or student_capacity < 100