CREATE TABLE table_18048 ("Incumbent" CLOB, "Reason for Vacancy" CLOB, "Appointed Successor" CLOB, "Date of Appointment" CLOB, "Elected Successor" CLOB, "Date of Election" CLOB)

What was the election date for H. Brent Coles?
SELECT "Date of Election" FROM table_18048 WHERE "Appointed Successor" = 'H. Brent Coles'
SELECT "Date of Election" FROM "table_18048" WHERE "Appointed Successor" = 'H. Brent Coles'