SQL Subquery Exercises: Display the department id and the total salary for those departments which contains at least one employee
SQL SUBQUERY: Exercise-22 with Solution
Write a query to display the department id and the total salary for those departments which contains at least one employee.
Sample table: employees
Sample table: departments
SELECT departments.department_id, result1.total_amt FROM departments, ( SELECT employees.department_id, SUM(employees.salary) total_amt FROM employees GROUP BY department_id) result1 WHERE result1.department_id = departments.department_id;
department_id total_amt 10 4400.00 20 19000.00 30 24900.00 40 6500.00 50 156400.00 60 28800.00 70 10000.00 80 304500.00 90 58000.00 100 51600.00 110 20300.00
N.B. : In certain instances not null is removed in table structure, so results may vary.
Contribute your code and comments through Disqus.
Previous: Write a query to display the employee name( first name and last name ) and department for all employees for any existence of those employees whose salary is more than 3700.
Next: Write a query to display the employee id, name ( first name and last name ) and the job id column with a modified title SALESMAN for those employees whose job title is ST_MAN and DEVELOPER for whose job title is IT_PROG.
What is the difficulty level of this exercise?