The short answer
SQL has:
TRUE
FALSE
UNKNOWNBecause NULL represents an unknown value.
So:
NULL = NULLis UNKNOWN.
It is not TRUE because SQL cannot prove two unknown values are equal.
That shows up in filters:
WHERE column = 10Rows where column is NULL do not pass, because the comparison is UNKNOWN.