PostgreSQL Aggregate Functions and Group By: Get the highest, lowest, total, and average salary of all employees

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

Sample Solution:

Code:

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

Sample table: employees

Output:

pg_exercises=# SELECT ROUND(MAX(salary),0) "Maximum",
pg_exercises-# ROUND(MIN(salary),0) "Minimum",
pg_exercises-# ROUND(SUM(salary),0) "Sum",
pg_exercises-# ROUND(AVG(salary),0) "Average"
pg_exercises-# FROM employees;
 Maximum | Minimum |  Sum   | Average
---------+---------+--------+---------
   24000 |    2100 | 691400 |    6462
(1 row)

Practice Online

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 in the department which ID is 90.
Next: Write a query to get the number of employees working in each post.