How many professionals did not operate any treatment on dogs?
create table professionals (professional_id varchar, PRIMARY KEY (professional_id)); create table treatments (professional_id varchar, PRIMARY KEY (professional_id))
select count(*) from professionals where not professional_id in (select professional_id from treatments)