Utilize the MAX and MIN functions to return the highest and lowest rates (hourly salary) in the"HumanResources.EmployeePayHistory" table. I encourage you to inspect the table and the examples in chapter VII before creating your query. Include your comments.

form a stored procedure that queries the database and returns a list of employees having degrees. Explain how you would solve this problem in case this task was not attainable.

form a query that drops a hypothetical stored proceduredbo.Tab_employee.