How many apartments do not have any facility?
CREATE TABLE Apartment_Facilities (
    apt_id VARCHAR
)

CREATE TABLE Apartments (
    apt_id VARCHAR
)
SELECT COUNT(*) FROM Apartments WHERE NOT apt_id IN (SELECT apt_id FROM Apartment_Facilities)
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: How many apartments do not have any facility? ### Input: CREATE TABLE Apartment_Facilities (
    apt_id VARCHAR
)

CREATE TABLE Apartments (
    apt_id VARCHAR
) ### Response: SELECT COUNT(*) FROM Apartments WHERE NOT apt_id IN (SELECT apt_id FROM Apartment_Facilities)