How does NULL behave in comparisons, aggregates and NOT IN?

Write or say your answer first, then compare it with the model answer.