Retrieve the first name, last name, and SSN of each employee along with the depa

Question

Retrieve the first name, last name, and SSN of each employee along with the department name he/she is working for.

Retrieve the number of employees of department 4.

Retrieve the names of employees who work on the project "ProjectX".

Retrieve the first name and last name of the male employee who has the highest salary.

Retrieve the first names and last names of the department managers who DON'T have a dependent

For each project, list its name, its controlling department's name, and its controlling department manager's first name and last name.

For the department that controls the most number of projects, list its name.

For each department, list its name along with the names of projects that it controls.

Explanation / Answer

SELECT Department, COUNT(Name) AS NumberOfEmployees, MIN(Salary) AS MinimumSalary, MAX(Salary) AS MaximumSalary, AVG(Salary) as AverageSalary FROM Employee WHERE Status='Active' GROUP BY Department

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.