Chapter 5 Exercise 19

19. Which paint colors were not used in 2012?

Easiest with subquery, otherwise need to save first query that gets paint that was used in 2012 and save it, then left join.
SELECT Paint.PaintID, Paint.ColorName
FROM Paint
WHERE Paint.PaintID NOT IN
(
SELECT DISTINCT PaintID
FROM Bicycle
WHERE OrderDate BETWEEN #1/1/2012# and #12/31/2012#
) ;