Pertemuan ke 7

SELECT *
FROM TABS

SELECT LAST_NAME, SALARY
FROM EMPLOYEES
WHERE SALARY > 12000;

SELECT LAST_NAME, DEPARTMENT_ID
FROM EMPLOYEES
WHERE employee_id=176;

DESCRIBE

SELECT last_name, salary
FROM EMPLOYEES
WHERE salary not BETWEEN 5000 AND 12000;


SELECT LAST_NAME, JOB_ID, HIRE_DATE
FROM EMPLOYEES
WHERE LAST_NAME in ('Taylor', 'Matos')
order by hire_date ASC;

SELECT LAST_NAME, DEPARTMENT_ID
FROM EMPLOYEES
WHERE DEPARTMENT_ID in (20,50)
order by last_name ASC;

SELECT last_name, salary as "Monthly salary"
FROM EMPLOYEES
WHERE salary BETWEEN 5000 AND 12000;
AND (department_id = 20 or department_id = 50);

SELECT LAST_NAME, HIRE_DATE
FROM EMPLOYEES
WHERE HIRE_DATE LIKE '%94';


SELECT LAST_NAME, JOB_ID
FROM EMPLOYEES
WHERE MANAGER_ID IS NULL;


SELECT LAST_NAME, SALARY, COMMISSION_PCT
FROM EMPLOYEES
WHERE COMMISSION_PCT IS NOT NULL
order by SALARY DESC, COMMISSION_PCT;