Amazon interview question

SQL questions on data manipulation involving window functions