Table: mayors_of_boise
Columns: incumbent
reason_for_vacancy
appointed_successor
date_of_appointment
elected_successor
date_of_election

Question: What was the election date for H. Brent Coles?
SQL: SELECT "date_of_election" FROM mayors_of_boise WHERE "appointed_successor" = 'H. Brent Coles'

Question: What was the election date for Arthur Hodges?
SQL: SELECT "date_of_election" FROM mayors_of_boise WHERE "elected_successor" = 'Arthur Hodges'