Chapter 4 Exercise 31

31. List all race bikes that sold in 2009 with a sale price greater than $5000. (1)

SELECT Bicycle.SerialNumber, Bicycle.ModelType, Bicycle.SalePrice, Bicycle.OrderDate FROM Bicycle
WHERE (((Bicycle.ModelType)="Road") AND ((Bicycle.OrderDate) Between #7/1/2005# And #7/31/2005#));
SELECT Bicycle.SerialNumber, Bicycle.ModelType, Bicycle.FrameSize, Bicycle.OrderDate, Bicycle.SalePrice
FROM Bicycle
WHERE (((Bicycle.ModelType)="Race") AND ((Bicycle.OrderDate) Between #1/1/2009# And #12/31/2009#) AND ((Bicycle.SalePrice)>5000));