Pergunta de entrevista da empresa Amazon

SQL based questions and medium level question based on Rank function and joins.