Question: Each record in the table department represents a department which might hire some employees. Each record in the table employee represents an employee who works

Each record in the table department represents a department which might hire some employees. Each record in the table employee represents an employee who works for one of the departments from the table department . The salary of each employee is known .( However , the locations of the departments are not relevant here .) Write an SQL query that returns a table comprising all the departments () in the table department that hire at least one employee , the number of people they employ and the sum of salaries in each department . The table should be ordered by ( increasing order ). For example , for :

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!