SELECT DEPT.DEPTNO,EMP.ENAME,EMP.MGR
FROM DEPT,EMP;

SELECT *
FROM DEPT,EMP,CUSTOMER;

SELECT ENAME,((SAL*12)+(1.5*SAL)) AS [ANNSAL]
FROM EMP;

SELECT ENAME
FROM EMP
WHERE COMM>SAL;

SELECT DNAME
FROM DEPT
WHERE DEPTNO>20;

SELECT ENAME
FROM EMP
WHERE JOB='MANAGER' AND SAL>2800;

SELECT ENAME
FROM EMP
WHERE JOB='MANAGER' OR SAL>2800;


SELECT ENAME
FROM EMP
WHERE DEPTNO!=30;