SELECT count(*) FROM Dogs WHERE dog_id NOT IN ( SELECT dog_id FROM Treatments )
How many dogs have not gone through any treatment?
SELECT count ( * ) FROM Dogs WHERE dog_id NOT IN ( SELECT dog_id FROM Treatments )
select count ( * ) from dogs where dog_id not in ( select dog_id from treatments )
How many dogs have not gone through any treatment ?