CREATE TABLE Apartment_Facilities (apt_id VARCHAR)
CREATE TABLE Apartments (apt_id VARCHAR)

How many apartments do not have any facility?
SELECT COUNT(*) FROM Apartments WHERE NOT apt_id IN (SELECT apt_id FROM Apartment_Facilities)
SELECT COUNT(*) FROM "Apartments" WHERE NOT "apt_id" IN (SELECT "apt_id" FROM "Apartment_Facilities")