Code: Select all
SELECT Person_Name, COUNT(Cats.PetID) AS cat_count, COUNT(Dogs.PetID) AS dog_count
FROM Person
LEFT JOIN Pets Cats ON Cats.OwnerID = Person.Person_ID AND Cats.Type = CAT
LEFT JOIN Pets Dogs ON Dogs.OwnerID = Person.Person_ID AND Dogs.Type = DOG