1、根据下 、根据下 列 表 结构写出 写出 SQL 语句每句 2 分1 列出所有 job_id 以 REP 为结尾的员工的姓名、编号和工资并把工资按降序排列2 查询员工的姓名以及在公司工作的月份数worked_month并按月份数降序排列排列3 查询出工资在 3000 到 5000 之间的 员工编号员工姓名所属部门编号部门名称4 查询所有部门的编号部门的名称部门经理 ID部门经理的姓名包含没有经

(1) SELECT e.ename, e.empno, e.sal FROM emp e WHERE e.job LIKE '%REP' ORDER BY e.sal DESC;

(2) SELECT e.ename, MONTHS_BETWEEN(SYSDATE, e.hiredate) AS worked_month FROM emp e ORDER BY worked_month DESC;

(3) SELECT e.empno, e.ename, d.deptno, d.dname FROM emp e JOIN dept d ON e.deptno = d.deptno WHERE e.sal BETWEEN 3000 AND 5000;

(4) SELECT d.deptno, d.dname, nvl(d.mgr, 'No Manager') AS mgr_id, nvl(m.ename, 'No Manager') AS mgr_name FROM dept d LEFT OUTER JOIN emp m ON d.mgr = m.empno;

(5) SELECT d.deptno, SUM(e.sal) AS total_salary FROM emp e JOIN dept d ON e.deptno = d.deptno GROUP BY d.deptno;