Nulls

NULLs are a datatype that specifies where no data exists in SQL. They are often ignored in our aggregation functions, which you will get a first look at in the next concept using COUNT.

When identifying NULLs in a WHERE clause, we write IS NULL or IS NOT NULL.

Notice that COUNT, AVG does not consider rows that have NULL values.