Chapter 4 Exercise 35

35. Find the greatest percentage discount (Discount/TotalList) received on a purchase order placed in 2013.

SELECT Manufacturer.ManufacturerName, [Discount]/[TotalList] AS PctDiscount, PurchaseOrder.OrderDate
FROM Manufacturer INNER JOIN PurchaseOrder
ON Manufacturer.ManufacturerID = PurchaseOrder.ManufacturerID
WHERE (((PurchaseOrder.OrderDate) Between #1/1/2013# And #12/31/2013#))
ORDER BY [Discount]/[TotalList] DESC;