Syntax:
COUNT(expr)

Returns a count of the number of non-NULL values of expr in the rows
retrieved by a SELECT statement. The result is a BIGINT value.

If there are no matching rows, COUNT() returns 0.

URL: http://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html

