Can someone really help me this is the second time I have to submit my question because the answers I been given are wrong, I keep getting Error's from the answers given here.

SQL-IS3351003-2022Sumr 5.3s Correlated subqueries 3 These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale, SaleItem, Product, Manufacturer, and Employee tables. For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed. These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale, Saleltem, Product, Manufacturer, and Employee tables. For each information request below, formulate a single SQL query to produce the required information. In each case, you should display on the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed. List Employees (first and last names) and their salaries of employees who have a salary higher than their managers. Use a correlated subnurerv in the WHF.RF. clause. Show employee information for the most recently hired employee in each city. (Most recent is Maximum hiredate). Use a correlated suhnueve in the WHFRF clanse Senuence the data he ritv Give a list of Manufacturer names and IDs for manufacturers which only provide products valued over $30, i.e. whose cheapest product's list price is over $30. (Hint: Use a correlated subquerv in WHERE clause) Give a list of customers (IDs and Names) whose purchases during the month of January 2014 were always the same color. (Hint: Use a single correlated subauerv with ioins. and count distinct colors of vurchased products in the WHERE clause.) Give a list of customers (IDs and names) who have purchased multiple items, but all of which were the same color. Multiple items means more than one sale items. Use what you learned in a previous problem about counting colors. Use subqueries in the WHERE clause. 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 ManufacturerID, State, and MaxListPrice. or each ManufacturerID and manufacturer name show the maximum list price of its products. Do this using a correlated subquery in the ELECT clause. Name the new column "MaxListPrice". For each sale with non-zero tax, list the saleID and saledate, tax, and shipping, as well as the total of the sale. This sale total includes the quantity * saleprice of all the sale items on the sale plus the tax and shipping. Do this with a correlated subquery in the SELECT clause. Show data for February 2015. Name the new column "TotalSale