GameStop Interview Question

SQL question with join window function