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.