Display the Empno, Ename, job, Hiredate, Exp of all Mgrs

Answer:

select empno,ename ,job,hiredate, months_between(sysdate,hiredate) exp from emp where empno in (select mgr from emp);