SQL STATEMENTS

1.List the unique product IDs, product descriptions, and prices, of all products that were ordered in quantities of less than five. Sort the list by price in descending order.

2. List the number of orders shipped to Florida that were handled by salespersons whose names begin with the letter J.

3. For each product of the Modern or Classical product lines, list the product description and ID along with the total quantity ordered of that product. Sort by product description.

4. List the names of all customers along with number of orders who have placed more than five orders. Sort by the number of orders, from highest to lowest.

5. List the names of all customers who placed orders during September (any year).

6.List the distinct product IDs and descriptions of all products that were not ordered in 2006

SalesPerson_T Order T P SalesPersonID POrderlD CustomerT SalesPersonName " CustomerID FulfilmentDate SaelsPersonFax SalesPersonAddress CustomerAddress F CustomerShipAddress T ShipAdrsID F SalesPerson_T_SalesPersonlD SalesPersonState SalesTerritorylD ProductT P ProductID ProductFinish ProductStanardPrice CustomerShipAddress OrderLine_T P OrderLinelD ShipAddressID TerritorylD ShipAddress ShipCity F ProductLine_T_ProductLinelD F Order_T-OrderID F Product_T_ProductID ShipZip ShipDirections Customer T ProductLine_T P ProductLinelD