1.查询出King所在部门的工作年限最大到的员工名字
select ename from emp where hiredate in(select min(hiredate) from emp where deptno in(select deptno from emp where ename='KING'));
2.查询出工资成本最高的部门的部门号和部门名称
select d.deptno,d.dname,t.sumsal from dept d,(select deptno,sum(sal) sumsal from emp group by deptno having sum(sal)=(select max(sum(sal)) from emp group by deptno)) t where d.deptno=t.deptno;
3.查询出King所在部门的部门号、部门名称、部门人数