Pregunta de entrevista de Amazon

Basic SQL queries around joins, grouping and some window functions