Table schema:
CREATE TABLE table_name_6 (vacator VARCHAR, reason_for_change VARCHAR)

Question: which Vacator has a Reason for change of resigned november 10, 1965?
SQL: SELECT vacator FROM table_name_6 WHERE reason_for_change = "resigned november 10, 1965"