FAQ: Aggregate Functions - Count

See this: What's the difference between COUNT(1), COUNT(*), and COUNT(column_name)?

The way CodeCademy introduces the COUNT() function is just misleading. After defining it as “counts the number of non-empty values in that column”, the first example they give is COUNT(*), no column specified, which is a special case where the COUNT function does count empty values as well…