Count Command

COUNT(*) : Returns the count of records in a table. NULL records are also included

COUNT(column_name) : Return no. of values in column which are not NULL

COUNT(DISTINCT column_name) : Return unique elements from an column

COUNT(1), COUNT(‘whatever’), COUNT(100) all have the same meaning as COUNT(*) and is executed in the same amount of time