Pergunta de entrevista da empresa Amazon

Basic SQL questions involving joins, Aggregate functions and window functions