How many owners temporarily do not have any dogs?
create table dogs (owner_id varchar, PRIMARY KEY (owner_id)); create table owners (owner_id varchar, PRIMARY KEY (owner_id))
select count(*) from owners where not owner_id in (select owner_id from dogs)