dobe Reader Help 2 / 2 100% e SERT Table Name: Employees D Name Deptid E0001 Brown 01 50002 White 02 E0003 Green 01 E0004 Neri 03 E0005 Brown 04 E0006 Chen 04 E0007 Bradshaw 01 E0008 Jackson 02 Salary 45,000 36,000 40,000 45,000 80,000 73,000 40,000 36,000 City London Toulouse Oxford Dover London Worthing Brighton London Table Name: Departments DeptId DeptName Address 01 Administration Bond Street 02 Production Rue Victor Hugo 03 Distribution Pond Road 04 Planning Bond Street 05 Research Sunset Street Consider a database containing the tables above and answer the following questions: a) Create view to list the number and average salary of employees in each department. The result should state the department name, number of employees, and average salary of employees for each department. b) Create AddEmployee stored procedure to add new employee and test it. c) Write a SELECT statement with the CASE expression to display the Salary as a text comment based on the salary range for an Employees table. For example: Salary 60,000 display 'Above $60,000