The special value
Real-life databases are often incomplete, but still must be queried.
To deal with this, SQL has a special value
that means either
The data is
Data in this field would have no
and the behaviour of SQL operators and functions
allows the user to deal with this sensibly.