1. select distinct job from emp;
2. select ename, job from emp where sal>2850;
3. select ename, deptno from emp where empno=7566;
4. select ename, sal from emp where sal not between 1500 and 2850;
5. select ename, hiredate from emp where hiredate >= '1981-02-20' and hiredate <= '1981-05-01' order by hiredate;
6. select ename, deptno from emp where deptno in (10,30) order by ename;
7. select ename as Employee, sal as "Monthly Salary" from emp where sal>1500 and deptno in (10,30);
8. select ename, hiredate from emp where hiredate like '1982%';
9.  select ename, job from emp where mgr is NULL;
10. select ename from emp where ename like '%L%L%' or ename like '__A%';
11. select ename from emp where job in ('CLERK', 'ANALYST') and sal not in (1000,3000,5000);