Part 1: Company Database Specify the following queries in SQL on the Company database 1. Retrieve the average salary of

[answerhappygod]

Part 1: Company Database Specify the following queries in SQL onthe Company database
1. Retrieve the average salary of all employees who works for‘Administration’ department
2. For each project, list project name and the total number ofemployee who work on the project
3. Retrieve the names of employees who work on every projectcontrolled by department 4
4. Retrieve the names of employee who are not departmentmanagers
5. List the last names of male employees who work on project‘Newbenefits’