Pregunta de entrevista de Intel Corporation

A SQL query that includes WINDOW FUNCTIONS, JOINS and more