Yes
select student_capacity from dorm where dorm_name = "Smith Hall"
How May female Dorm are there?
select count ( * ) from dorm where gender = "F"
Yes
select amenity_name from dorm_amenity
List name of all amenities which Anonymous Donor Hall has, and sort the result in alphabetic order.
select t1.amenity_name from dorm_amenity as t1 join has_amenity as t2 on t2.amenid = t1.amenid join dorm as t3 on t2.dormid = t3.dormid where t3.dorm_name = 'Anonymous donor Hall' order by t1.amenity_name