w3resource
ankara escort
malatya escort
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.

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.

What is the difficulty level of this exercise?

New Exercises:R Programming