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 Segunda Parte onde Sir Christopher William Codrington é o Primeiro Membro e Hon. Francis Charteris é o Segundo Membro?
 ###Tabelas: CREATE TABLE members_of_parliament (members_of_parliament_id AUTO_INCREMENT PRIMARY KEY, Election VARCHAR, 1st Member VARCHAR, 1st Party VARCHAR, 2nd Member VARCHAR, 2nd Party VARCHAR) CREATE TABLE american_football_league (american_football_league_id AUTO_INCREMENT PRIMARY KEY, Year INT, Round INT, Pick INT, Overall INT, Player name VARCHAR, Position VARCHAR, AFL team VARCHAR) CREATE TABLE races_and_results (races_and_results_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, Incumbent VARCHAR, Party VARCHAR, Elected INT, Status VARCHAR, 2008 Candidates VARCHAR, Results VARCHAR) CREATE TABLE top_10_across_all_platforms (top_10_across_all_platforms_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Actor VARCHAR, Character VARCHAR, Soap Opera VARCHAR, Years VARCHAR, Duration VARCHAR) CREATE TABLE 2009_season_schedule (2009_season_schedule_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Opponent VARCHAR, Home / Away VARCHAR, Score VARCHAR, High points VARCHAR, High rebounds VARCHAR, High assists VARCHAR, Location/Attendance VARCHAR, Record VARCHAR)  
SELECT 2nd Party FROM members_of_parliament WHERE 1st Member = sir christopher william codrington AND 2nd Member = hon. francis charteris