SQL: NOT IN with a NULL in the subquery returns no rows at all

NOT IN expands to a chain of <> comparisons. One NULL makes every comparison UNKNOWN, and UNKNOWN is not TRUE, so the whole predicate fails for every row - an empty result set from a query that looks obviously correct.

Full code & output

This topic is available to PRO members.