ÿþ<html> <head><title>Answers</title></head> <body> <p>29. List the SalePrice of Road bicycles ordered in July 2005.</p> <p>SELECT Bicycle.SerialNumber, Bicycle.ModelType, Bicycle.SalePrice, Bicycle.OrderDate<br /> FROM Bicycle<br /> WHERE (((Bicycle.ModelType)= Road ) AND ((Bicycle.OrderDate) Between #7/1/2005# And #7/31/2005#));</p> <p>30. List the Road components introduced after 2003 with a weight greater than 400 grams but do not include wheels.</p> <p>SELECT Component.Road, Component.Category, Component.Year, Component.Weight<br /> FROM Component<br /> WHERE (((Component.Road)= Road ) AND ((Component.Category) Not Like  *wheel* ) AND ((Component.Year)>2003) AND ((Component.Weight)>400));</p> <p>31. List all of the employees with a salary of more than $40,000.</p> <p>SELECT Employee.EmployeeID, Employee.LastName, Employee.Salary<br /> FROM Employee<br /> WHERE (((Employee.Salary)>40000));</p> <p>32. List the purchase orders placed in January 2007 in descending order by total list price.</p> <p>SELECT PurchaseOrder.PurchaseID, PurchaseOrder.TotalList, PurchaseOrder.OrderDate<br /> FROM PurchaseOrder<br /> WHERE (((PurchaseOrder.OrderDate) Between #1/1/2007# And #1/31/2007#))<br /> ORDER BY PurchaseOrder.TotalList DESC;</p> <p>34. List the customers who live in Miami, Florida.</p> <p>SELECT Customer.CustomerID, Customer.Phone, Customer.FirstName, Customer.LastName, City.City, City.State<br /> FROM City RIGHT JOIN Customer ON City.CityID = Customer.CityID<br /> WHERE (((City.City)= Miami ) AND ((City.State)= FL ));<p> </body> </html>