Pergunta de entrevista da empresa Amazon

Basic SQL queries around joins, grouping and some window functions