Pregunta de entrevista de Gartner

A sql query which involves the use of RANK.