user: ### NOW ANSWER:
Question: What is the lowest ranking for Paul McTiernan?
Columns: ['Ranking', 'Nationality', 'Name', 'Years', 'Goals']
Types: ['real', 'text', 'text', 'text', 'real']
Sample row: [1.0, 'Scotland', 'Johnny Armstrong', '1952–1964', 138.0]
SQL:

assistant: SELECT MIN("Ranking") FROM "Table" WHERE "Name" = 'Paul McTiernan';