CREATE TABLE table_66989 ("Riding" CLOB, "Candidate's Name" CLOB, "Gender" CLOB, "Residence" CLOB, "Occupation" CLOB, "Votes" FLOAT, "Rank" CLOB)

what is the candidates name who is ranked 8th?
SELECT "Candidate's Name" FROM table_66989 WHERE "Rank" = '8th'
SELECT "Candidate's Name" FROM "table_66989" WHERE "Rank" = '8th'