Pergunta de entrevista da empresa Macquarie Group

SQL - how to get the 3rd item when there are items with the same value.