Oracle SQL: How to Find Department Wise Average Salary
How to Find Department Wise Average Salary from Table of Employees?
SELECT B.DEPTNO, B.DNAME, avg(sal) AS avg_salary
FROM EMP A, DEPT B
WHERE A.DEPTNO(+) = B.DEPTNO
GROUP BY B.DEPTNO, B.DNAME