How many customers are located in Florida? 2. List all states (CustomerState) where there is at least one customer. Do not repeat the same state in your result table. 3. Display OrderID, ProductID, OrderDate and OrderedQuantity for orders made after October 23, 2010, with at least four units for a product. 4.

Display CustomerID, CustomerName and OrderID of all customer orders. Include in this list any customer who has no orders in the database.

5. Display a list of products (show ProductID and ProductDescription as the first two columns) for the products that have been ordered for at least three times. Display (as the third column) the number of times these products have been ordered.

6. Find ProductID, OrderedQuantity, ProductStandardPrice and total price (= OrderedQuantity x ProductStandardPrice) for each product that has been ordered by customer #5.

7. Find all customers (show CustomerID and CustomerName) who have not placed any order.

8. List OrderID, ProductID and OrderedQuantity for all customer orders for which the order quantity is greater than the overall average order quantity.