What is the difference between `COUNT(column)` and `COUNT(*)` when NULL values are present?

Question

Advanced SQL Developer — Medium

What is the difference between `COUNT(column)` and `COUNT(*)` when NULL values are present?

Accepted Answer

COUNT(column) only counts non-NULL values, while COUNT(*) includes all rows, even those with NULL values in the specified column. This distinction is crucial when dealing with NULL values in SQL queries.