Create a stored procedure to retrieve SSN$,$ first name, last name, and salary for the employees belonging to the department, given the department name.

Create a stored procedure to update supervisor for a specified employee, given employee SSN and then new supervisor SSN$.$

Create a stored procedure to retrieve a list of all employees whose salary is above the average salary in their department.

Create a function to calculate the age of an employee spouse, given the employee SSN$.$

Create a function to calculate and average salary of all employees who work for a department, given the department name.