w3resource

PostgreSQL Basic SELECT Statement: Get the average salary and number of employees are working


8. Write a query to get the average salary and number of employees are working.

Sample Solution:

Code:

SELECT AVG(salary), COUNT(*) 
FROM employees;

Sample table: employees


Output:

pg_exercises=# SELECT AVG(salary), COUNT(*)
pg_exercises-# FROM employees;
          avg          | count
-----------------------+-------
 6461.6822429906542056 |   107
(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 maximum and minimum salary paid to the employees.
Next: Write a query to get the number of employees working with the company.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook