SQLite Exercise: Get the department ID and the total salary payable in each department

Write a query to get the department ID and the total salary payable in each department.

Sample table : employees

SQLite Code:

SELECT department_id, SUM(salary)
FROM employees 
GROUP BY department_id;

Output:

department_id  SUM(sa
-------------  ------
10             4400
20             19000
30             24900
40             6500
50             156400
60             28800
70             10000
80             304500
90             58000
100            51600
110            20300
               7000

Relational Algebra Expression:

Relational Algebra Tree:

Practice SQLite Online

Model Database

Structure of 'hr' database :

Improve this sample solution and post your code through Disqus.

Previous: Write a query to find the manager ID and the salary of the lowest-paid employee for that manager.
Next: Write a query to get the average salary for each job ID excluding programmer.