/*---------------------------- C #1 ----------------------------*/

/* SELECT ENAME, DEPTNO, SAL
FROM EMP
WHERE SAL BETWEEN 1000 AND 2000; */

/*SELECT DEPTNO, DNAME
FROM DEPT
ORDER BY DEPTNO DESC;*/

/* SELECT DISTINCT JOB
FROM EMP; */

/* SELECT *
FROM EMP
WHERE DEPTNO = 10 OR DEPTNO = 20
ORDER BY JOB ASC; */

/* SELECT ENAME
FROM EMP
WHERE DEPTNO = 20 AND JOB = 'CLERK'; */

/* SELECT ENAME
FROM EMP
WHERE ENAME LIKE '%TH%' OR ENAME LIKE '%LL%'; */

/* SELECT ENAME, SAL
FROM EMP
WHERE SAL NOT BETWEEN 1000 AND 2000
AND LENGTH(ENAME) = 5; */

/* SELECT ENAME, JOB, SAL
FROM EMP
WHERE ENAME NOT LIKE '%L%'
AND SAL != 800 AND SAL != 1600 AND SAL != 3000; */

/* SELECT ENAME, JOB, SAL
FROM EMP
WHERE MGR IS NOT NULL; */

--SELECT ENAME, SAL * 12 - NVL(COMM, 0) AS ANNSAL
--FROM EMP
--WHERE JOB = 'SALESMAN';

/*---------------------------- C #2 ----------------------------*/

--SELECT * FROM EMP, DEPT
--WHERE DEPT.DEPTNO = EMP.DEPTNO;

--SELECT EMP.ENAME, DEPT.DNAME
--FROM EMP, DEPT
--WHERE EMP.DEPTNO = DEPT.DEPTNO
--ORDER BY EMP.ENAME ASC;

--SELECT EMP.ENAME, EMP.DEPTNO, DEPT.DNAME
--FROM EMP, DEPT
--WHERE EMP.DEPTNO = DEPT.DEPTNO;

--SELECT EMP.ENAME, DEPT.LOC, DEPT.DNAME
--FROM EMP, DEPT
--WHERE EMP.DEPTNO = DEPT.DEPTNO AND EMP.SAL > 1500;

--SELECT EMP.ENAME, EMP.JOB, EMP.SAL, SALGRADE.GRADE
--FROM EMP, SALGRADE
--WHERE EMP.SAL BETWEEN SALGRADE.LOSAL AND SALGRADE.HISAL;

--SELECT *
--FROM EMP, SALGRADE
--WHERE EMP.SAL BETWEEN SALGRADE.LOSAL AND SALGRADE.HISAL AND SALGRADE.GRADE = 3;

--SELECT EMP.ENAME
--FROM EMP, DEPT
--WHERE EMP.DEPTNO = DEPT.DEPTNO AND DEPT.LOC = 'DALLAS';

--8 OUTER JOIN
--SELECT EMP.ENAME, EMP.DEPTNO
--FROM EMP, DEPT
--WHERE EMP.DEPTNO(+) = DEPT.DEPTNO;

--9

--10
--SELECT DISTINCT JOB
--FROM EMP
--WHERE DEPTNO = 10 OR DEPTNO = 30;

--11
SELECT JOB
FROM EMP
WHERE DEPTNO = 10
INTERSECT
SELECT JOB
FROM EMP
WHERE DEPTNO = 30;

--12