human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: District, Vacator, Reason for change, Successor, Date successor seated
###Question: Who was the successor when the vacator was chester e. holifield (d)?
gpt
SELECT Successor FROM table WHERE Vacator = Chester E. Holifield (D)