Chapter 4 Exercise 31

31. List the phone number of all women who purchased race bikes with white in the color in 2012.

SELECT Customer.CustomerID, Customer.Phone, Customer.LastName, Customer.Gender, Bicycle.ModelType, Paint.ColorList, Bicycle.OrderDate
FROM Paint INNER JOIN (Customer INNER JOIN Bicycle
ON Customer.CustomerID = Bicycle.CustomerID) ON Paint.PaintID = Bicycle.PaintID
WHERE (((Customer.Gender)="F") AND ((Bicycle.ModelType)="Race") AND ((Paint.ColorList) Like "*WHITE*")
AND ((Bicycle.OrderDate) Between #1/1/2012# And #12/31/2012#));