w3resource
w3resource logo
SQLite exercises

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

Sqlite Online Editor


Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.



Amazon promo codes to get huge discounts for limited period (USA only).