human 5 已知Oracle的示例数据库使用scott用户完成下列查询：1列出所有员工的年工资按年薪从低到高排序。2列出各个部门的MANAGER经理的最高薪金。3列出各类工作的工作名称、最低工资、最高工资、所有员工列表以逗号间隔每类工作占一行。提示：员工列表用wm_concat函数4列出所有部门的详细信息和部门人数。5列出每个部门工作的员工数量及部门名称。6 列出没有任何员工的部门信息。7 检

AI: 1.

SELECT ename, sal*12 as annual_salary FROM emp ORDER BY sal;

SELECT deptno, MAX(sal) as max_salary FROM emp WHERE job = 'MANAGER' GROUP BY deptno;

SELECT job, MIN(sal) as min_salary, MAX(sal) as max_salary, wm_concat(ename) as employees FROM emp GROUP BY job;

SELECT deptno, dname, loc, COUNT(*) as num_employees FROM dept, emp WHERE dept.deptno = emp.deptno GROUP BY deptno, dname, loc;

SELECT deptno, dname, job, COUNT(*) as num_employees FROM emp, dept WHERE emp.deptno = dept.deptno GROUP BY deptno, dname, job;

SELECT deptno, dname, loc FROM dept WHERE deptno NOT IN (SELECT deptno FROM emp);

SELECT * FROM emp WHERE loc != 'NEW YORK';

DELETE FROM emp WHERE loc = 'NEW YORK'