Pergunta de entrevista da empresa Amazon

SQL questions that involved the use of window functions and ctes.