Chapter 4 Exercise 44

44. Which customer purchased the most number of Road and Race bikes combined (for all dates)?

SELECT Customer.CustomerID, Customer.LastName, Customer.Phone,
Count(Bicycle.SerialNumber) AS CountOfSerialNumber
FROM Customer INNER JOIN Bicycle ON Customer.CustomerID = Bicycle.CustomerID
WHERE (((Bicycle.ModelType)="Race" Or (Bicycle.ModelType)="Road"))
GROUP BY Customer.CustomerID, Customer.LastName, Customer.Phone
ORDER BY Count(Bicycle.SerialNumber) DESC;