Pergunta de entrevista da empresa GameStop

SQL question with join window function