Operator: NOT IN <>
:select dname, loc from dept where loc <> 'CHICAGO'
Oracle:
PostgreSQL