Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual é a classificação de Walter Noel de St. John's?
 ###Tabelas: CREATE TABLE results_by_year (results_by_year_id AUTO_INCREMENT PRIMARY KEY, Year INT, Men's Open VARCHAR, Women's Open VARCHAR, Mixed Open VARCHAR, Men's u20 VARCHAR, Women's u20 VARCHAR, Senior Mixed VARCHAR, Men's 30 VARCHAR, Women's 30 VARCHAR, Men's 35 VARCHAR, Women's 35 VARCHAR, Men's 40 VARCHAR, Women's 40 VARCHAR, Men's 45 VARCHAR, Men's 50 VARCHAR) CREATE TABLE north_carolina (north_carolina_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, Incumbent VARCHAR, Party VARCHAR, Elected INT, Status VARCHAR, Opponent VARCHAR) CREATE TABLE defunct_callsigns (defunct_callsigns_id AUTO_INCREMENT PRIMARY KEY, Callsign VARCHAR, Area served VARCHAR, Band VARCHAR, Freq currently VARCHAR, Purpose VARCHAR) CREATE TABLE 2003_fedex_ground_winners (2003_fedex_ground_winners_id AUTO_INCREMENT PRIMARY KEY, Week INT, Player VARCHAR, Team VARCHAR, Opponent VARCHAR, Carries INT, Yards INT, Average VARCHAR, Touchdowns INT) CREATE TABLE -_7_seats (-_7_seats_id AUTO_INCREMENT PRIMARY KEY, Riding VARCHAR, Candidate's Name VARCHAR, Gender VARCHAR, Residence VARCHAR, Occupation VARCHAR, Votes INT, Rank VARCHAR)  
SELECT Rank FROM -_7_seats WHERE Residence = st. john's AND Candidate's Name = walter noel