Pregunta de entrevista de Grant Street Group

SQL question which involved using window functions