COUNT vs COUNT(*) vs COUNT(column) — NULL behavior.

COUNT and NULL

• COUNT(*) counts rows including NULLs in columns.
• COUNT(col) ignores NULL values in col.
• AVG/SUM ignore NULL—skew averages if NULL means something.

SELECT COUNT(*) , COUNT(email) FROM users;