NOT
Negates a condition, as in NOT rating = 'R'; it also combines with other keywords as NOT IN, NOT LIKE and NOT EXISTS.
When to use
Not asked in the past papers or problem sets. In Read 01, AND binds tighter than OR, so brackets are needed around what you mean when mixing them with NOT.
See Read 01.