In SQL:2008 and most SQL standards, NULL values are ignored by all aggregate functions like COUNT, SUM, AVG, MIN, MAX, etc. COUNT(*) counts all rows including NULLs, but COUNT(column) ignores NULLs. This behavior ensures aggregate calculations don't get skewed by unknown/missing values.