Filtering Records by NULL Values
How to use the WHERE statement to filter records when a value IS NULL or IS NOT NULL in a T-SQL statement.
NULL
NULL Values and Aggregate Functions
How to work with NULL values in Aggregate Functions in a T-SQL statement. How to fix issues with NULL values with the AVG() and COUNT() functions.