Yurttas/PL/DBL/oracle/F/01/Company-A/q07.sql
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;