Use IS NULL conditions in subqueries to NULL values represent missing unknown data.
The syntax for IS NULL conditions is:
expression IS [ NOT ] NULL
Without the NOT keyword, the IS NULL condition is TRUE if the expression is the NULL value, and FALSE otherwise. The NOT keyword reverses the meaning of the condition.