How many apartments do not have any facility?
create table apartment_facilities (apt_id varchar, PRIMARY KEY (apt_id)); create table apartments (apt_id varchar, PRIMARY KEY (apt_id))
select count(*) from apartments where not apt_id in (select apt_id from apartment_facilities)