Find the name of dorms that do not have any amenity
CREATE TABLE has_amenity (
    dorm_name VARCHAR,
    dormid VARCHAR
)

CREATE TABLE dorm (
    dorm_name VARCHAR,
    dormid VARCHAR
)
SELECT dorm_name FROM dorm WHERE NOT dormid IN (SELECT dormid FROM has_amenity)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the name of dorms that do not have any amenity ### Input: CREATE TABLE has_amenity (
    dorm_name VARCHAR,
    dormid VARCHAR
)

CREATE TABLE dorm (
    dorm_name VARCHAR,
    dormid VARCHAR
) ### Response: SELECT dorm_name FROM dorm WHERE NOT dormid IN (SELECT dormid FROM has_amenity)