GameStop interview question

SQL question with join window function