Hastings Direct interview question

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