Question: GA: 3 . 4 . Departments with the highest number employees! Employee Department Salary _ Grade Name Type empID INT empName VARCHAR ( 2 5
GA: Departments with the highest number employees!
Employee Department SalaryGrade
Name Type
empID INT
empName VARCHAR
jobTitle VARCHAR
managerID INT
hireDate DATE
salary REAL
comission REAL
deptID INT
Name Type
deptID INT
deptName VARCHAR
deptLocation VARCHAR
Name Type
grade INT
minSalary REAL
maxSalary REAL
Write one SQL query to return the department name, location, number of employees of the departments with the highest number of employees. Output the result in ascending order by the employee count and in descending order by the department name.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
