dunnhumby interview question

General SQL related and statistics questions.