Recall that the meaning of COUNT(*) is to count all records where any of the fields are non-zero.
Recall that the meaning of COUNT(*) is to count all of the records where any of the fields are non-null.  