A missing value in SQL is NULL, which means "unknown", not zero or an empty string. Because it is unknown, = NULL never matches anything, and you must write IS NULL or IS NOT NULL. Reach for this whenever a column can be empty, like a manager id for the CEO. NULL handling is a favourite interview trap, so learn how it affects comparisons, counts and sorting.