Amazon interview question

sql in not in, window function