Chapter 4 Exercise 47

47. Which employee sold the most bikes by value in November 2012?

SELECT Employee.EmployeeID, Employee.LastName,
Sum(Bicycle.SalePrice) AS SumOfSalePrice
FROM Employee INNER JOIN Bicycle ON Employee.EmployeeID = Bicycle.EmployeeID
WHERE (((Bicycle.OrderDate) Between #11/1/2012# And #11/30/2012#))
GROUP BY Employee.EmployeeID, Employee.LastName
ORDER BY Sum(Bicycle.SalePrice) DESC;