MySQL Aggregate Function Exercises: Get the highest, lowest, sum, and average salary of all employees

MySQL Aggregate Function: Exercise-6 with Solution

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

Sample table: employees

Code:

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

Pictorial Presentation of the above query

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) 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.