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: Me informe o D 47 para D 46 de r 35.
 ###Tabelas: CREATE TABLE 1970_isle_of_man_lightweight_tt_250cc_final_standings (1970_isle_of_man_lightweight_tt_250cc_final_standings_id AUTO_INCREMENT PRIMARY KEY, Place INT, Rider VARCHAR, Country VARCHAR, Machine VARCHAR, Speed VARCHAR, Time VARCHAR, Points INT) CREATE TABLE race_calendar_and_winners (race_calendar_and_winners_id AUTO_INCREMENT PRIMARY KEY, Round INT, Circuit VARCHAR, Date VARCHAR, Fastest lap VARCHAR, Winning driver VARCHAR, Winning team VARCHAR, Winning manufacturer VARCHAR) CREATE TABLE westbound_record_breakers_blue_riband_holders (westbound_record_breakers_blue_riband_holders_id AUTO_INCREMENT PRIMARY KEY, Ship VARCHAR, Year INT, Dates VARCHAR, Line VARCHAR, From VARCHAR, Distance VARCHAR, Days, hours, minutes VARCHAR, Speed VARCHAR) CREATE TABLE senate_composition_before_the_elections (senate_composition_before_the_elections_id AUTO_INCREMENT PRIMARY KEY, D 41 VARCHAR, D 42 VARCHAR, D 43 VARCHAR, D 44 VARCHAR, D 45 VARCHAR, D 46 VARCHAR, D 47 VARCHAR, R 53 VARCHAR, R 52 VARCHAR, R 51 VARCHAR) CREATE TABLE high_school_players_and_coaches_of_the_year_1989-1997 (high_school_players_and_coaches_of_the_year_1989-1997_id AUTO_INCREMENT PRIMARY KEY, Year INT, Player VARCHAR, Position VARCHAR, High School VARCHAR, Hometown VARCHAR, MLB Draft VARCHAR)  
SELECT D 47 FROM senate_composition_before_the_elections WHERE D 46 = r 35