Objective : NOT IN operation filtering job other than clerk and sales man.
SELECT * FROM emp WHERE job NOT IN ('CLERK','ANALYST')
Oracle:
PostgreSQL