12.21作业

select e.empno,e.ename,d.loc,m.ename
from emp e
join dept d
on e.deptno = d.deptno
join emp m
on e.mgr = m.empno
where e.ename = 'smith';

select ename,dname,sal,grade
from emp e
join dept d
on e.deptno = d.deptno
join salgrade
where sal between losal and hisal and grade > 4;

select e.ename,m.ename
from emp e
join dept d
on e.deptno = d.deptno
join emp m
on e.mgr = m.empno
where e.ename in ('ford','king');

select e.ename,e.hiredate,m.ename,m.hiredate
from emp e 
join emp m 
on e.mgr = m.empno
where m.hiredate > e.hiredate;