SELECT dorm_name FROM dorm WHERE dormid NOT IN (SELECT dormid FROM has_amenity)
Find the name of dorms that do not have any amenity
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 )
Find the name of dorms that do not have any amenity