Syntax:
AVG([DISTINCT] expr)

Returns the average value of expr. The DISTINCT option can be used to
return the average of the distinct values of expr.

If there are no matching rows, AVG() returns NULL.

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

