oracle中用emp和dept这些表。 这几道题怎么做

把你的用到的表的表名和字段列出来，我帮你写

1.select deptno, job, avg(sal) from emp group by deptno, job having avg(sal)<=1500 2. select a.empno, a.ename, a.deptno, b.loc from emp a, dept b where a.deptno=b.deptno and a.ename='king' 3.select a.ename, a.job, a.sal form emp a, dept b where a.deptno=b.deptno and b.loc='new york' 4. select a.ename, a.job, a.sal form emp a, dept b where a.deptno=b.deptno and b.dname in ('accounting','sales')