COUNT(*) – Returns the total number of records in a table (Including NULL valued records).
COUNT(Column Name) – Returns the total number of Non-NULL records. It means that, it ignores counting NULL valued records in that particular column.
In the below screenshot, LastName of EmployeeID 3 is NULL. So It will not be counted when we are counting records on the basis of LastName (i.e. COUNT(LastName)).