---

SELECT empno, ename, job, mgr, hiredate, sal, comm, deptno FROM emp;
SELECT ename, job, sal FROM emp;
SELECT job FROM emp;
SELECT DISTINCT job FROM emp;
SELECT DISTINCT job, sal FROM emp;
SELECT job, sal FROM emp;
SELECT * FROM emp;
SELECT ename, ' работает в ', deptno, ' отделе' FROM emp;
SELECT ename, sal*12, comm/3 FROM emp;
SELECT ename  ' работает на должности '  job FROM emp;
SELECT ename, length(ename) FROM emp;
SELECT ename, job, sal*12+comm FROM emp;
SELECT ename, job, sal*12+COALESCE(comm,0) FROM emp;
SELECT ename, sal FROM emp ORDER BY sal;
SELECT ename, sal FROM emp ORDER BY sal, ename;
SELECT ename, sal FROM emp ORDER BY sal DESC;
SELECT ename, sal FROM emp ORDER BY sal DESC, ename;
SELECT ename, deptno FROM emp ORDER BY sal, mgr;
SELECT ename, sal, 2000 FROM emp ORDER BY abs(sal-2000);
SELECT ename, sal FROM emp ORDER BY 2, 1;
SELECT ename, sal*12+COALESCE(comm,0) FROM emp ORDER BY 2;
SELECT ename, sal*12+COALESCE(comm,0) YEARSAL FROM emp ORDER BY YEARSAL;
SELECT ename Фамилия FROM emp;
SELECT ename AS Фамилия FROM emp;
SELECT ename "Фамилия сотрудника", sal "Оклад сотрудника" FROM emp ORDER BY "Оклад сотрудника";
SELECT ename, job FROM emp WHERE sal>2000;
SELECT * FROM emp WHERE sal>2000 ORDER BY ename;
SELECT ename FROM emp WHERE job='MANAGER';
SELECT ename, sal FROM emp WHERE deptno=20;
SELECT ename FROM emp WHERE sal>2000 OR job='ANALYST';
SELECT ename FROM emp WHERE sal>2000 AND deptno=20;
SELECT * FROM emp WHERE job='CLERK' AND sal<1000 OR job='MANAGER' AND sal<2500;
SELECT * FROM emp WHERE job='CLERK' AND (sal<1000 OR job='MANAGER') AND sal<2500;
SELECT ename, sal FROM emp WHERE sal BETWEEN 1000 AND 2000;
SELECT ename, sal FROM emp WHERE job IN ('CLERK','MANAGER','SALESMAN');
SELECT ename, sal FROM emp WHERE sal IN (1000,2000);
SELECT ename, sal FROM emp WHERE (sal*12+COALESCE(comm,0) BETWEEN 10000 AND 25000 OR sal<1000) AND job IN ('CLERK','SALESMAN');
SELECT ename, job FROM emp WHERE comm IS NOT NULL;
SELECT ename, job FROM emp WHERE mgr IS NULL;
SELECT ename FROM emp WHERE ename LIKE '%L%';
SELECT ename FROM emp WHERE ename LIKE '___T%';