- /*
-
- SQL> SELECT DPTNAME,AVG(SALARY),COUNT(*) FROM
- 2 (SELECT
- 3 (SELECT DEPT.DEPARTMENT_NAME FROM DEPARTMENTS DEPT
- 4 WHERE DEPT.DEPARTMENT_ID = EMP.DEPARTMENT_ID) DPTNAME,
- 5 EMP.SALARY
- 6 FROM EMPLOYEES EMP)
- 7 GROUP BY DPTNAME
- 8 ORDER BY DPTNAME;
-
- DPTNAME AVG(SALARY) COUNT(*)
-
- Accounting 10150 2
- Administration 4400 1
- Executive 21333.33333 3
- Finance 8600 6
- Human Resources 6500 1
- IT 5760 5
- Marketing 9500 2
- Public Relations 10000 1
- Purchasing 4150 6
- Sales 8973.852941 34
- Shipping 3475.555555 45
- 7000 1
- 12 rows selected
-
-
-
- SQL> SELECT DEPT.DEPARTMENT_NAME,AVG(EMP.SALARY),COUNT(*)
- 2 FROM EMPLOYEES EMP,DEPARTMENTS DEPT
- 3 WHERE EMP.DEPARTMENT_ID = DEPT.DEPARTMENT_ID
- 4 GROUP BY DEPT.DEPARTMENT_NAME
- 5 ORDER BY DEPT.DEPARTMENT_NAME;
-
- DEPARTMENT_NAME AVG(EMP.SALARY) COUNT(*)
-
- Accounting 10150 2
- Administration 4400 1
- Executive 21333.333333333 3
- Finance 8600 6
- Human Resources 6500 1
- IT 5760 5
- Marketing 9500 2
- Public Relations 10000 1
- Purchasing 4150 6
- Sales 8973.8529411764 34
- Shipping 3475.5555555555 45
-
- 11 rows selected
|