课后作业第三章

--课后作业第三章--1SELECT ename 员工姓名,hiredate 入职时间,job 职位FROM empWHERE hiredate > '9-7月-1982'AND job NOT IN ('SALESMAN')--2SELECT ename 员工姓名FROM empWHERE ename LIKE '__a%'--3SELECT ename 员工姓名,deptno 部门编号FROM empWHERE deptno NOT IN(10,20)--4SELECT *FROM empWHERE deptno = 30ORDER BY sal DESC,ename--5SELECT ename 员工姓名FROM empWHERE mgr IS NULL--6SELECT ename 员工姓名,sal 工资,deptno 部门编号FROM empWHERE deptno IN(10,20)AND sal >=4500