Nice catch, Google searched it: > Not everyone realizes this, but the COUNT function will only count the records where the expression is NOT NULL in COUNT(expr

Nice catch, Google searched it: > Not everyone realizes this, but the COUNT function will only count the records where the expression is NOT NULL in COUNT(expression) . When the expression is a NULL value, it is not included in the COUNT calculations.