Find the location that has average salary more than 4000 dollars. Usually each location may have several departments. A) select loc from dept, emp where dept.deptno = emp.deptno group by loc having...

Find the location that has average salary more than 4000 dollars. Usually each location may
have several departments.
A) select loc from dept, emp where dept.deptno = emp.deptno group by loc having avg(sal) > 4000;
B) select loc from emp group by loc having avg(sal) > 4000;
C) select loc from dept group by loc having avg(sal) > 4000;
D) select loc from dept where deptno in (select deptno from emp group by loc having avg(sal) > 4000);
E) select loc from dept where deptno in (select deptno from emp group by deptno having avg(sal) > 4000);