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 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 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?
- Exercises: Weekly Top 12 Most Popular Topics
- Pandas DataFrame: Exercises, Practice, Solution
- Conversion Tools
- JavaScript: HTML Form Validation
- SQL Exercises, Practice, Solution - SUBQUERIES
- C Programming Exercises, Practice, Solution : For Loop
- Python Exercises, Practice, Solution
- Python Data Type: List - Exercises, Practice, Solution
- C++ Basic: Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - exercises on Employee Database
- SQL Exercises, Practice, Solution - exercises on Movie Database
- SQL Exercises, Practice, Solution - exercises on Soccer Database
- C Programming Exercises, Practice, Solution : Recursion