﻿ PostgreSQL Aggregate Functions and Group by: Get the highest, lowest, total, and average salary of all employees - 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