Find the name of dorms that do not have any amenity
create table dorm (dorm_name varchar, dormid varchar, PRIMARY KEY (dorm_name)); create table has_amenity (dorm_name varchar, dormid varchar, PRIMARY KEY (dorm_name))
select dorm_name from dorm where not dormid in (select dormid from has_amenity)