w3resource
SQLite exercises

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

Sqlite Online Editor


Structure of 'hr' database :

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.

What is the difficulty level of this exercise?