Tambahan 3

SELECT last_name, salary

         FROM employees

WHERE salary > 12000;

SELECT last_name, department_id

         FROM employees

WHERE employee_id = 176;

SELECT last_name, salary

         FROM employees

WHERE salary NOT BETWEEN 5000 AND 12000

ORDER BY salary ASC;

SELECT last_name, department_id

         FROM employees

WHERE department_id = 20

OR department_id = 50 

ORDER BY last_name ASC;

SELECT last_name, salary

   FROM employees

WHERE salary BETWEEN 5000 AND 12000

AND department_id = 20

OR department_id = 50;

SELECT last_name, TO_CHAR(hire_date, 'DD Month YYYY') AS HIREDATE

         FROM employees

WHERE TO_CHAR(hire_date, 'YYYY') = 1994;

SELECT last_name

FROM employees

WHERE first_name LIKE '%a%'

AND first_name LIKE '%e%';

first_name, salary, department_id

   FROM employees

WHERE SELECT  salary > '5000'

AND salary < '15000'

AND first_name LIKE '%y%'

AND (department_id = '50'

OR department_id = '60'

OR department_id = '90');