NULL means a value is missing. It is different from zero, an empty string and the text 'NULL'. Test missing values with IS NULL or IS NOT NULL. Equality against NULL produces unknown, which a WHERE clause won't keep.
Aggregates handle missing values differently. COUNT(*) counts rows, while COUNT(amount) counts recorded amounts. SUM ignores missing amounts and returns NULL for an empty input. COALESCE supplies a fallback when that fallback matches the business meaning. An unknown amount should not silently become a confirmed zero.
Contact imports often contain whitespace. NULLIF(TRIM(email), '') turns blank contact details into missing values before you count them. Keep the source ID so two missing email addresses never collapse into one customer. These exercises distinguish absent values from valid zero amounts and space-only text.
Use IS NULL; a zero amount is known and differs from an unknown amount.