Can you provide me with the names of the dorms that have both TV Lounge and Study Room as amenities?
select t1.dorm_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 t3.amenity_name = 'TV Lounge' intersect select t1.dorm_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 t3.amenity_name = 'Study Room'
What is the Dorm ID of Dorm-plex 2000?
select dormid from dorm where dorm_name = "Dorm-plex 2000"
What is the student capacity of Dorm-plex 2000?
select student_capacity from dorm where dorm_name = "Dorm-plex 2000"
What genders can be residents of Dorm-plex 2000?
select gender from dorm where dorm_name = "Dorm-plex 2000"