Logical Operators: AND, OR, NOT
AND
SELECT * FROM employees WHERE department_id = 50 AND salary > 3000;OR
SELECT * FROM employees WHERE department_id = 50 OR department_id = 60;NOT
SELECT * FROM employees WHERE NOT job_id = 'SA_REP';SELECT * FROM employees WHERE department_id = 50 AND salary > 3000;SELECT * FROM employees WHERE department_id = 50 OR department_id = 60;SELECT * FROM employees WHERE NOT job_id = 'SA_REP';