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

What is the rank of walter noel from st. john's?
SELECT "Rank" FROM table_69397 WHERE "Residence" = 'st. john''s' AND "Candidate's Name" = 'walter noel'
SELECT "Rank" FROM "table_69397" WHERE "Candidate's Name" = 'walter noel' AND "Residence" = 'st. john''s'