Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
'Count': Counts the number of non-null values.
'Count (*)': Counts the number of rows in the table, including null values and duplicates.