Can you show me the dorms with female only students?
select * from dorm where gender = "F"
okay, can you show me all the names of dorm with male only students?
select * from dorm where gender = "M"
what about the name of the dorms that are both male and female?
select * from dorm where gender = "M" or gender = "F"
show me the name of dorms that are no gender specific?
select dorm_name from dorm where gender = "X"
Show me all dorm names
select dorm_name from dorm
Can you tell me which one of them do not have TV Lounge?
select dorm_name from dorm except 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'
and which one DO have TV Lounge?
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'