SQL Cookbook

When invoking aggregate functions, always give thought to how you want NULLs handled.

Ref. EB91-A

It is important to note that the COUNT function will ignore NULLs when passed a column name as an argument, but will include NULLs when passed the “*” character or any constant; consider:

Ref. 4431-B