select * from emp;

SELECT ENAME, JOB FROM emp;


SELECT ENAME, JOB FROM emp
WHERE SAL BETWEEN 2000 AND 3000;

SELECT * FROM emp
WHERE hiredate like '%1981';

UPDATE emp
Set sal = sal+1000
Where job = 'SALESMAN';

SELECT * FROM EMP;

SELECT ENAME FROM EMP
WHERE ENAME LIKE '%S%';

INSERT INTO EMP VALUES (1002, 'Aguinaldo', 'Manager', NULL, SYSDATE, 5000, NULL, 20);

SELECT * FROM EMP;

SELECT * FROM CUSTOMERS;

SELECT FULL_NAME FROM CUSTOMERS
ORDER BY FULL_NAME DESC;

SELECT AVG(SAL) AS "AVERAGE SALARY" FROM EMP;

SELECT MIN(SAL) AS MINIMUM, MAX(SAL) AS MINIMUM, SUM(SAL) AS TOTAL FROM EMP;


SELECT COUNT(CUSTOMER_ID) FROM CUSTOMERS;

UPDATE EMP
SET JOB = 'SUPERVISOR'
WHERE JOB = 'MANAGER';

SELECT * FROM EMP;]

SELECT * FROM EMP
WHERE JOB = 'SUPERVISOR' AND SAL <= 2500;


SELECT * FROM EMP
WHERE COMM IS NULL;


SELECT * FROM DEPT;

SELECT * FROM EMP, DEPT;


--NATURAL JOIN
SELECT EMPNO, ENAME, DNAME, LOC
FROM EMP NATURAL JOIN DEPT;

--CROSS JOIN
SELECT EMPNO, ENAME, DNAME, LOC
FROM EMP CROSS JOIN DEPT;


SELECT e.empno, e.ename, d.dname, d.loc
FROM emp e LEFT OUTER JOIN dept d
ON (e.deptno=d.deptno);

SELECT e.empno, e.ename, d.dname, d.loc
FROM emp e RIGHT OUTER JOIN dept d
ON (e.deptno=d.deptno);

SELECT e.empno, e.ename, d.dname, d.loc
FROM emp e FULL OUTER JOIN dept d
ON (e.deptno=d.deptno);