Epsilon interview question

SQL questions involving multiple joins, date functions, self join, window functions