Amazon interview question

Different SQL queries and windowing functions