How many apartments have no facilities?
SELECT count ( * )  FROM Apartments WHERE apt_id NOT IN  ( SELECT apt_id FROM Apartment_Facilities ) 
apartments with no facilities refers to selecting apartments that do not have a corresponding entry in the Apartment_Facilities table; counting the number of such apartments is done using COUNT(*)