user: ### NOW ANSWER:
Question: which Vacator has a Reason for change of Resigned November 10, 1965?
Columns: ['State (class)', 'Vacator', 'Reason for change', 'Successor', "Date of successor's formal installation"]
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['South Carolina (3)', 'Olin D. Johnston (D)', 'Died April 18, 1965', 'Donald S. Russell (D)', 'April 22, 1965']
SQL:

assistant: SELECT "Vacator" FROM "Table" WHERE "Reason for change" = 'Resigned November 10, 1965';