SQL ONLY-
Given Tables-
Employee (EmployeeID, FirstName, LastName,Address)
Department (DeptNo, DepartmentName, City)
DepartmentEmployee(DeptNo, EmployeeID,Position)
Project (ProjectNo, ProjectName, DeptNo)
Project Team ( ProjectNo, EmployeeID, Role)
MAKE THE QUERY FOR-
1. List the name and position of all the employee who works inthe (DeptNo = ‘22C’).
2. List the total number of employees in each department forthose departments with more than 5 employees.
3. List the project number, project name and the number ofemployees who worked on each project role.
