COUNT, AVG, and the NULLs Your Aggregates Ignore

· by · in

COUNT(column), AVG, and COUNT(DISTINCT) ignore NULL but COUNT(*) does not, so totals stop matching. How to pick the right aggregate.