29. List the SalePrice of Road bicycles ordered in July 2005.

SELECT Bicycle.SerialNumber, Bicycle.ModelType, Bicycle.SalePrice, Bicycle.OrderDate
FROM Bicycle
WHERE (((Bicycle.ModelType)=”Road”) AND ((Bicycle.OrderDate) Between #7/1/2005# And #7/31/2005#));

30. List the Road components introduced after 2003 with a weight greater than 400 grams but do not include wheels.

SELECT Component.Road, Component.Category, Component.Year, Component.Weight
FROM Component
WHERE (((Component.Road)=”Road”) AND ((Component.Category) Not Like “*wheel*”) AND ((Component.Year)>2003) AND ((Component.Weight)>400));

31. List all of the employees with a salary of more than $40,000.

SELECT Employee.EmployeeID, Employee.LastName, Employee.Salary
FROM Employee
WHERE (((Employee.Salary)>40000));

32. List the purchase orders placed in January 2007 in descending order by total list price.

SELECT PurchaseOrder.PurchaseID, PurchaseOrder.TotalList, PurchaseOrder.OrderDate
FROM PurchaseOrder
WHERE (((PurchaseOrder.OrderDate) Between #1/1/2007# And #1/31/2007#))
ORDER BY PurchaseOrder.TotalList DESC;

34. List the customers who live in Miami, Florida.

SELECT Customer.CustomerID, Customer.Phone, Customer.FirstName, Customer.LastName, City.City, City.State
FROM City RIGHT JOIN Customer ON City.CityID = Customer.CityID
WHERE (((City.City)=”Miami”) AND ((City.State)=”FL”));