Attributes in SQL can have the value of NULL unless if they are specified with NOT NULL constraints. It means unknown data and does not necessarily mean false.
SQL follows a three-value logic system:
We can check whether a value is NULL using IS and IS NOT as SQL considers each NULL value distinct from other NULL values.
SELECT name
FROM employee
WHERE super_ssn IS NULL