user: Question: Who was the successor when the vacator was Chester E. Holifield (D)?
Columns: ['District', 'Vacator', 'Reason for change', 'Successor', 'Date successor seated']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Michigan 7th', 'Donald W. Riegle, Jr. (R)', 'Switched party affiliation', 'Donald W. Riegle, Jr. (D)', 'February 27, 1973']
SQL:

assistant: SELECT "Successor" FROM "Table" WHERE "Vacator" = 'Chester E. Holifield (D)';