SQLite Exercise: Get the highest, lowest, sum, and average salary of all employees

Write a query to get the highest, lowest, sum, and average salary of all employees.

Sample table: employees

SQLite Code:

SELECT ROUND(MAX(salary),0) "Maximum",
ROUND(MIN(salary),0) "Minimum",
ROUND(SUM(salary),0) "Sum",
ROUND(AVG(salary),0) "Average"
FROM employees;

Output:

Maximum     Minimum     Sum         Average
----------  ----------  ----------  ----------
24000.0     2100.0      691400.0    6462.0

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 average salary and number of employees working the department 90.
Next: Write a query to get the number of employees with the same job.