Yurttas/PL/DBL/oracle/F/01/Company-A/q07.sql
Jump to navigation
Jump to search
1REM
2REM q07.sql
3REM
4REM For each department, retrieve the department name and the
5REM average salary of employees working in that department.
6REM
7
8SELECT dname, AVG(salary)
9FROM Department, Employee
10WHERE dnumber = dno
11GROUP BY dname;