Pregunta de entrevista de GameStop

SQL question with join window function