SELECT count(*) FROM Apartments WHERE apt_id NOT IN (SELECT apt_id FROM Apartment_Facilities)
Find the number of apartments that have no 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 )
Find the number of apartments that have no facility .