list the info of all dorms.
select * from dorm
what is the capacity of Anonymous Donor Hall?
select student_capacity from dorm where dorm_name = 'Anonymous donor Hall'
List all of the amenities that it has.
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'
sort the results 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