Using the (AND / OR / NOT) Operator

select employ_id, last_name, job_id, salary

from employees

where salary >= 10000

and job_id Like '%MAN%' ;

 

select employ_id, last_name, job_id, salary

from employees

where salary >= 10000

or job_id Like '%MAN%' ;

 

select last_name, job_id

from employees

where job_id

          not in('IT_PROG', 'ST_CLERK', 'SA_REP') ;