Pregunta de entrevista de Amazon

Basic SQL questions involving joins, Aggregate functions and window functions