Amazon Interview Question

sql in not in, window function