A basic assumption of nearly any database is that the absence of data in a table is recorded as NULL. This fundamental principle guides many of the approaches an individual would take to querying the data within. The behavior of common operators like COUNT, ISNULL, IFNULL, MAX, are predicated on the interpretation of NULL rows.