Part 2 on Stored Procedure :Create Stored Procedure SP_ Dept_Productivity that does the following tasks: It creats a new table Dept_ProductivityThe...

Part 2 on Stored Procedure :Create Stored Procedure SP_ Dept_Productivity that does the following tasks:1. It creats a new table Dept_ProductivityThe table has 5 Columns as follow:Dept_Name, Dept_Number, EmpCount, Sum_Salary, ProjectCountUse “Create Table” without any constraints.2. Use “Insert Select” to populate the table. Write Select query to join with the ViewVDept_Budget that you created in Part 1-3) to list Employee Headcount, Sum ofSalary, The Number of the Projects that each department controls with dnumberand dname for each department. PopuIate the table with “Insert… Select”.Include all the departments in the list.3. Show the content of the table with (Select * from Dept_Productivity;)Execute your stored procedure to get the output with Exec SP_Dept_Productivity ;Output (snapshot of screen) each part to show the creation of the View and theupdated Views, the contents of the view and the updated view for the Part 1.For Part 2, Screenshot for each step to show Creation of the Stored Procedure,and Execution the SP to show the contents of the new table

Someone already answered on course hero but I am not able to extract it.Please help.