Question: GA: 3 . 4 . Departments with the highest number employees! Employee Department Salary _ Grade Name Type empID INT empName VARCHAR ( 2 5

GA:3.4. Departments with the highest number employees!
Employee Department Salary_Grade
Name Type
empID INT
empName VARCHAR(255)
jobTitle VARCHAR(100)
managerID INT
hireDate DATE
salary REAL
comission REAL
deptID INT
Name Type
deptID INT
deptName VARCHAR(30)
deptLocation VARCHAR(255)
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!