Create a list that shows each department name, # of employees, maximum salary, minimum salary, total salary, and standard deviation of the salaries.
- Create a list that shows each department name, # of employees, maximum salary, minimum salary, total salary, and standard deviation of the salaries.
EMP Table:
Field
---------------------------------------
EMPNO
ENAME
JOB
MGR
HIREDATE
SAL
COMM
DEPTNO
DEPT Table:
Field
------------------------------- -------- --------------------------------------------------------------------
DEPTNO
DNAME
LOC
First EMP and DEPT tables have to join basing deptno in both.
Then group them by using dname.
Then apply aggregate functions.
Step by step
Solved in 2 steps
