tsql can count return null?
Commonly, expression is the name of a field, (or an expression containing one or more field names) in the multiple rows returned by a query. COUNT(expression) does not count NULL values. It can optionally count or not count duplicate field values.