w3resource

SQLite Exercise: Get the total salaries payable to employees

Write a query to get the total salaries payable to employees.

Sample table : employees


SQLite Code :

SELECT SUM(salary) 
FROM employees;

Output:

SUM(salary)
-----------
691400

Relational Algebra Expression:

Relational Algebra Expression: Get the total salaries payable to employees.

Relational Algebra Tree:

Relational Algebra Tree: Get the total salaries payable to employees.

Practice SQLite Online


Model Database

Employee Model  Database - w3resource online SQLite practice

Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.

Previous: Write a query to get the employee ID, names (first_name, last_name), salary in ascending order of salary.
Next: Write a query to get the maximum and minimum salary from employees table.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook