mysql avg() does not include NULL

mysql avg() does not include NULL.

for example

The AVG does not include the column which value is null.