Find the name of the amenities that Smith Hall dorm has.
select t3.amenity_name from dorm as t1 join has_amenity as t2 on t1.dormid = t2.dormid join dorm_amenity as t3 on t2.amenid = t3.amenid where t1.dorm_name = 'Smith Hall'
Order that by amenity name please?
select t3.amenity_name from dorm as t1 join has_amenity as t2 on t1.dormid = t2.dormid join dorm_amenity as t3 on t2.amenid = t3.amenid where t1.dorm_name = 'Smith Hall' order by t3.amenity_name
What are the amenity id of those?
select t2.amenid from dorm as t1 join has_amenity as t2 on t1.dormid = t2.dormid join dorm_amenity as t3 on t2.amenid = t3.amenid where t1.dorm_name = 'Smith Hall' order by t3.amenity_name
What dorm id have the amenity id 901?
select t2.dormid from has_amenity as t2 where t2.amenid = 901
What dorm id have the amenity id 904?
select t2.dormid from has_amenity as t2 where t2.amenid = 904
What dorm id have the amenity id 922?
select t2.dormid from has_amenity as t2 where t2.amenid = 922