Chapter 5 Exercise 2

2. Which employees did not sell any items in June?

(subquery can include date directly, otherwise save view that includes the date to force it to apply first, then use left join)
SELECT EmployeeID, LastName
FROM Employee
WHERE EmployeeID NOT IN
(SELECT EmployeeID
FROM Sale
WHERE SaleDate BETWEEN #6/1/2013# and #6/30/2013#
);