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 foi a data da eleição para H. Brent Coles?
 ###Tabelas: CREATE TABLE former_special_cities_now_core_or_designated_cities (former_special_cities_now_core_or_designated_cities_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Japanese VARCHAR, Date of designation VARCHAR, Date of reclassification VARCHAR, Region VARCHAR, Prefecture VARCHAR) CREATE TABLE passages (passages_id AUTO_INCREMENT PRIMARY KEY, Incumbent VARCHAR, Reason for Vacancy VARCHAR, Appointed Successor VARCHAR, Date of Appointment VARCHAR, Elected Successor VARCHAR, Date of Election VARCHAR) CREATE TABLE nascar_camping_world_truck_series (nascar_camping_world_truck_series_id AUTO_INCREMENT PRIMARY KEY, Year INT, Starts INT, Wins INT, Top 5 INT, Top 10 INT, Poles INT, Avg. Start VARCHAR, Avg. Finish VARCHAR, Winnings VARCHAR, Position VARCHAR, Team(s) VARCHAR) CREATE TABLE versions (versions_id AUTO_INCREMENT PRIMARY KEY, Release INT, Title VARCHAR, Start INT, Pieces INT, Board (inches) VARCHAR, Board (cm) VARCHAR, Type VARCHAR, New units New units when compared to the original A&A: Classic version of the game. VARCHAR, Playable Powers VARCHAR) CREATE TABLE bush_battles (bush_battles_id AUTO_INCREMENT PRIMARY KEY, Battle No. INT, Broadcast Date VARCHAR, Name of Battle VARCHAR, Theme VARCHAR, Celebrities Taking Part VARCHAR, Winner VARCHAR, Runner-up VARCHAR, Notes VARCHAR)  
SELECT Date of Election FROM passages WHERE Appointed Successor = H. Brent Coles