Table: Employees r

EmployeelD INT PRIMARY KEY

FirstName VARCHAR$(50)$

LastName VARCHAR$(5$O$)$

$\text{'}$ JobTitle VARCHAR$($I$00)$

Salary DECIMAL$(10,2)$

$.$

HireDate DATE

DepartmentlD INT

Table: Departments

DepartmentlD INT PRIMARY KEY

DepartmentName VARC HAR$($ I $00)$

ManagerlD INT

Foneign Key: Employees.DepartmentlD references Departments.DepartmentlD

Frame SQL queries for the following problems:

$($i$)$ Calculate the average salary per department.

$($ii$)$ List the employees with the highest salary in each department:

I

$($iiD Find departments with more than $25$ employees.

$($iv$)$ Get the employee names starting with $\text{'}$S$\text{'}$ in alphabetical order