SELECT d.loc
FROM   emp e, dept d, salgrade s
WHERE  e.deptno = d.deptno AND
       e.sal BETWEEN s.losal AND s.hisal AND
       s.grade = 2;



SELECT e1.ename, e2.ename
FROM   emp e1, emp e2
WHERE  e1.mgr = e2.mgr;