list all dorm amenities.
select amenity_name from dorm_amenity
Find the names of dorms that have some of these amenities.
select dorm_name from dorm where dormid in (select dormid from has_amenity)
Find the names of dorms that do not have any amenities.
select dorm_name from dorm where dormid not in (select dormid from has_amenity)