Chapter 5 Exercise 4

4. Which breed of Cat has never been adopted through the store?

Be sure to include the condition for not adopted (SaleID is null)
SELECT Breed
FROM Breed
WHERE Category="Cat"
AND Breed NOT IN
(SELECT Breed
FROM Animal
WHERE Category="Cat"
AND SaleID Is NOT Null)
;