Question$-1$

You have been assigned to create a database procedure that calculates the average salary of

employees in a specific department. Write a stored procedure in SQL that takes the department ID as

input and returns the average salary of employees in that department. Assume you have the

following tables:

Table: Employees

Table: Departments

Please write a stored procedure named GetAverageSalaryByDepartment that accepts a department

ID as a parameter and returns the average salary of employees in that department. If the department

ID is invalid, the procedure should return an error message saying "the department does not exist".

Note: You can assume that the department IDs are unique and refer to valid departments in the

Departments table.

Please provide the SQL code for the GetAverageSalaryByDepartment stored procedure.