Pergunta de entrevista da empresa Gartner

A sql query which involves the use of RANK.