Customer Product Manufacturer ManufacturerID ManufacturerName Addressi Address2 City State PostalCode Phone Fax Contact URL Sale Saleltem CustomerID FirstName LastName StreetAddress City State PostalCode Country Phone SalelD SaleDate CustomerID Tax Shipping SaleID ProductiD ItemSize Quantity SalePrice ProductID ProductName ManufacturerID Composition ListPrice Gender Category Color Description Employee EmployeelD o FirstName LastName Address City State ZIP Phone ManagerlD SSN EmailAddress HireDate SalaryEmployee EmployeelD o Salary WageEmployee EmployeelD o Wage MaxHours For each sale with non-zero tax, list the saleID and saledate, tax, shipping, the total amount of the sale (all saleitems), and the sum of the tax plus shipping plus total from saleitems. Total amount of the sale is the quantity * saleprice from each saleitem and totaled for the entire sale. Do this using a subquery in the FROM clause. Show sales for February 2015. Name the total for each sale "SaleTotal" For each manufacturer (ManufacturerID) show the maximum list price of its products. Show only those manufacturers whose products have an average list price below the average list price of products from manufacturers in their state, and put the result in order by state. Use a correlated subquery in the HAVING clause. Show ManufacturerllD State, and MaxListPrice