Amazon interview question

sql questions related to window functions