Amazon Interview Question

SQL questions on data manipulation involving window functions