Amazon interview question

Basic SQL questions involving joins, Aggregate functions and window functions