Chapter 4 Exercise 39

39. How many Race bikes were sold to women in each state in 2013?

SELECT Bicycle.SaleState, Count(Bicycle.SerialNumber) AS CountOfSerialNumber
FROM Customer INNER JOIN Bicycle ON Customer.CustomerID = Bicycle.CustomerID
WHERE (((Customer.Gender)="F")
AND ((Bicycle.ModelType)="Race") AND ((Bicycle.OrderDate) Between #1/1/2013# And #12/31/2013#))
GROUP BY Bicycle.SaleState;