Epsilon interview question

Advanced SQL questions.