user: ### NOW ANSWER:
Question: what is the candidates name who is ranked 8th?
Columns: ['Riding', "Candidate's Name", 'Gender', 'Residence', 'Occupation', 'Votes', 'Rank']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Chilliwack—Fraser Canyon', 'Harold J. Ludwig', 'M', 'Abbotsford', 'Retired', 653.0, '5th']
SQL:

assistant: SELECT "Candidate's Name" FROM "Table" WHERE "Rank" = '8th';