SELECT AVG(e.sal),d.dname,d.locFROM emp e,dept dWHERE e.deptno=d.deptnoGROUP BY d.dname,d.locHAVING AVG(e.sal)>2000
select dname,loc from dept where deptno in(select distinct deptno from emp where sal >2000);
