What is the rank of walter noel from st. john's?
CREATE TABLE "7_seats" (
  "riding" text,
  "candidate_s_name" text,
  "gender" text,
  "residence" text,
  "occupation" text,
  "votes" real,
  "rank" text
);
SELECT "rank" FROM "7_seats" WHERE "residence"='st. john''s' AND "candidate_s_name"='walter noel';