Frage im Vorstellungsgespräch bei Amazon

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