w3resource

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
---------+---------+--------+---------
   24030 |    2130 | 685080 |    6463
(1 row)

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming