user: ### NOW ANSWER:
Question: What is the Highest finish with a Most recent finish that was 2nd?
Columns: ['Club', 'Town or city', 'Total seasons', 'Total spells', 'Longest spell', 'Last promotion', 'Last SPL season', 'Years absent', 'Seasons', 'Most recent finish', 'Highest finish']
Types: ['text', 'text', 'real', 'real', 'real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Aberdeen', 'Aberdeen', 16.0, 1.0, 16.0, '1905–06', '2012—13', '—', '1998–2013', '8th', '3rd']
SQL:

assistant: SELECT "Highest finish" FROM "Table" WHERE "Most recent finish" = '2nd';