user: Question: What was the election date for H. Brent Coles?
Columns: ['Incumbent', 'Reason for Vacancy', 'Appointed Successor', 'Date of Appointment', 'Elected Successor', 'Date of Election']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['L. B. Lindsay', 'Disqualified, never took office', 'Henry E. Prickett', 'November 19, 1867', 'Thomas B. Hart', 'January 1868']
SQL:

assistant: SELECT "Date of Election" FROM "Table" WHERE "Appointed Successor" = 'H. Brent Coles';