Table: vacancy_successors
Columns: district
vacator
reason_for_change
successor
date_successor_seated

Question: When was the date successor seated when the vacator was charles e. chamberlain (r)?
SQL: SELECT "date_successor_seated" FROM vacancy_successors WHERE "vacator" = 'Charles E. Chamberlain (R)'

Question: Who was the successor when the vacator was chester e. holifield (d)?
SQL: SELECT "successor" FROM vacancy_successors WHERE "vacator" = 'Chester E. Holifield (D)'

Question: When was the successor seated when the district was California 10th?
SQL: SELECT "date_successor_seated" FROM vacancy_successors WHERE "district" = 'California 10th'

Question: Who was the vacator when the date successor seated was august 21, 1973?
SQL: SELECT "vacator" FROM vacancy_successors WHERE "date_successor_seated" = 'August 21, 1973'

Question: What was the district when the reason for change was died January 1, 1974?
SQL: SELECT "district" FROM vacancy_successors WHERE "reason_for_change" = 'Died January 1, 1974'