Pregunta de entrevista de Epsilon

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