#

View the Exhibit and examine the structures of DEPT and EMP tables.

You need to generate a report that displays department names along with the corresponding average salary.

Which SQL statement would give the required result?

   A. SELECT dname, AVG(sal)
      FROM emp LEFT OUTER JOIN dept USING(deptno)
      GROUP BY dname;;
   B. SELECT dname, AVG(sal)
      FROM emp JOIN dept USING(deptno)
      GROUP BY dname,sal;
   C. SELECT dname, sal
      FROM emp JOIN dept USING(deptno)
      GROUP BY dname HAVING sal= AVG(sal);
   D. ELECT dname, AVG(sal)
      FROM emp FULL OUTER JOIN dept USING(deptno)
      GROUP BY dname;