SELECT count(*) FROM Apartments WHERE apt_id NOT IN (SELECT apt_id FROM Apartment_Facilities)
How many apartments do not have any facility?
SELECT count ( * ) FROM Apartments WHERE apt_id NOT IN ( SELECT apt_id FROM Apartment_Facilities )
select count ( * ) from apartments where apt_id not in ( select apt_id from apartment_facilities )
How many apartments do not have any facility ?