Handle NULLS
SQL treats NULLS differently in set operations (UNION, INTERSECT, EXCEPT) than it does when handing NULLS in joins and scans.
When rows are compared, SQL treats set operations NULL values as equal to each other; that is, the evaluation expression (NULL = NULL) produces the result TRUE. Whereas in join or scan operations, the same NULL equality expression evaluates to UNKNOWN.