Chapter 4 Exercise 5

5. List employees who participated in adoptions of female dogs in March.

SELECT Employee.EmployeeID, Employee.LastName, Sale.SaleDate, Animal.Category
FROM Employee INNER JOIN (Sale INNER JOIN Animal
ON Sale.SaleID = Animal.SaleID) ON Employee.EmployeeID = Sale.EmployeeID
WHERE (((Sale.SaleDate) Between #3/1/2013# And #3/13/2013#)
AND ((Animal.Category)="Dog"));