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 eleição tem um 2º membro de frederick knight e um 1º membro de sir edmund lechmere, bt?
 ###Tabelas: CREATE TABLE tracklist (tracklist_id AUTO_INCREMENT PRIMARY KEY, Artist/Band VARCHAR, Song VARCHAR, Disney affiliated VARCHAR, Released INT, US exclusive VARCHAR, EU exclusive VARCHAR) CREATE TABLE production (production_id AUTO_INCREMENT PRIMARY KEY, Autonomous Community VARCHAR, Hydroelectric power INT, Wind power INT, Solar power INT, Biomass power INT, Solid waste power INT, Total Renewable Generation INT, Total Electricity Demand INT, % Renewable of Total Electricity Demand VARCHAR) CREATE TABLE louisville (louisville_id AUTO_INCREMENT PRIMARY KEY, Position VARCHAR, Number INT, Name VARCHAR, Height VARCHAR, Weight INT, Class VARCHAR, Hometown VARCHAR, Games↑ INT) CREATE TABLE third_division (third_division_id AUTO_INCREMENT PRIMARY KEY, Scorer VARCHAR, Club VARCHAR, League goals VARCHAR, FA Cup goals INT, League Cup goals VARCHAR, Total INT) CREATE TABLE mps_1832–1885 (mps_1832–1885_id AUTO_INCREMENT PRIMARY KEY, Election VARCHAR, 1st Member VARCHAR, 1st Party VARCHAR, 2nd Member VARCHAR, 2nd Party VARCHAR)  
SELECT Election FROM mps_1832–1885 WHERE 2nd Member = frederick knight AND 1st Member = sir edmund lechmere, bt