/*ECT ename
FROM EMP
WHERE com>sal;


SELECT dname
FROM DEPT
where deptno>20;


SELECT mgr
FROM EMP
WHERE sal>2800;


SELECT ename
FROM EMP
WHERE (sal>2800 OR job='MANAGER');


SELECT ename
FROM EMP 
WHERE (JOB='MANAGER' AND deptno<>30);
*/
SELECT *
FROM EMP
ORDER BY sal