Pregunta de entrevista de Amazon

SQL - They asked to write a query using Rank