SELECT dorm_name FROM dorm WHERE dormid NOT IN (SELECT dormid FROM has_amenity)
What are the names of all the dorms that don't have any amenities?
SELECT dorm_name FROM dorm WHERE dormid NOT IN ( SELECT dormid FROM has_amenity )
select dorm_name from dorm where dormid not in ( select dormid from has_amenity )
What are the names of all the dorms that do n't have any amenities ?