Find the name of dorms that do not have any amenity
CREATE TABLE dorm (dorm_name VARCHAR, dormid VARCHAR); CREATE TABLE has_amenity (dorm_name VARCHAR, dormid VARCHAR)
[SQL] SELECT dorm_name FROM dorm WHERE NOT dormid IN (SELECT dormid FROM has_amenity) [/SQL]