QUERY BERSYARAT

SELECT salary FROM employees GROUP BY salary HAVING salary<16000 ORDER BY salary

SELECT first_name, employee_id FROM employees WHERE employee_id>=200

SELECT first_name FROM employees WHERE first_name LIKE '%lex%'

SELECT last_name FROM employees WHERE last_name NOT LIKE 'A%'

SELECT first_name,job_id FROM employees WHERE job_id IN('AD_VP','FI_MGR')

SELECT first_name,hire_date FROM employees WHERE hire_date BETWEEN '1-JUN-98' AND '21-AUG-99' ORDER BY hire_date