Pregunta de entrevista de Hastings Direct

Why did you use mean rather than average? What does the COALESCE function do in SQL?