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;