question: which Vacator has a Reason for change of resigned november 10, 1965?
answer: SELECT vacator FROM table_name_6 WHERE reason_for_change = "resigned november 10, 1965"
context: CREATE TABLE table_name_6 (vacator VARCHAR, reason_for_change VARCHAR)