user: Question: What is the rank of Walter Noel from St. John's?
Columns: ['Riding', "Candidate's Name", 'Gender', 'Residence', 'Occupation', 'Votes', 'Rank']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Avalon', 'Scott Andrews', 'M', 'Conception Bay South', 'Municipal Councillor', 14866.0, '1st']
SQL:

assistant: SELECT "Rank" FROM "Table" WHERE "Residence" = 'St. John''s' AND "Candidate's Name" = 'Walter Noel';