In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed.

1)For each manufacturer in New York state that supplies at least 10 products, what is the average list price of products from that manufacturer? Name column AveragePrice. Round to two decimal places. Show manufacturer name and rounded average price, to 2 decimal places.

2) What are the largest amounts for a sale item (SalePrice * Quantity) made to each customer (first and last name). Include only customers who have bought a sale item over $225. Name the column MaxAmount.

3)What are the dollar amounts of each Sale (add all SaleItem amounts) for each customer? Include CustomerID, SaleID, but only inlude sales larger than $600. Name the column TotalAmt.

4)Make a list of products that were sold during February 2015. Show ProductID and ProductName. Also include in your result table the maximum and the minimum amount of a saleItem (quantity * SalePrice). Name these fields MaxPrice and MinPrice. Only include those products that have a maximum > minimum. (This means that there were multiple sales during that time period, else the maximum would equal the minimum.) Sort the result by ProductID.

Customer Sale Saleltem Product Manufacturer CustomerID SaleID OT SaleID ProductID ManufacturerlDO 0 FirstName SaleDate ProductD 01 ProductName ManufacturerName LastName CustomerID Item Size 0 ManufacturerID Address 1 Tax Quantity Composition Address2 StreetAddress City Shipping Sale Price ListPrice City State Gender State PostalCode PostalCode Category Country Employee Employeeld FirstName Phone O Color Phone Fax Description LastName Contact Address SalaryEmployee Employeeld Salary 0 URL City State ZIP Phone WageEmployee Employeeld 0 ManagerID Wage SSN MaxHours EmailAddress Customer Sale Saleltem Product Manufacturer CustomerID SaleID OT SaleID ProductID ManufacturerlDO 0 FirstName SaleDate ProductD 01 ProductName ManufacturerName LastName CustomerID Item Size 0 ManufacturerID Address 1 Tax Quantity Composition Address2 StreetAddress City Shipping Sale Price ListPrice City State Gender State PostalCode PostalCode Category Country Employee Employeeld FirstName Phone O Color Phone Fax Description LastName Contact Address SalaryEmployee Employeeld Salary 0 URL City State ZIP Phone WageEmployee Employeeld 0 ManagerID Wage SSN MaxHours EmailAddress