user: Question: Who was appointed on October 24, 1997?
Columns: ['Name', 'Background', 'Title', 'Appointment', 'Presentation of Credentials']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['William H. Christensen', 'Non-career appointee', "Chargé d'Affaires ad interim", 'August 31, 1962', 'August 31, 1962']
SQL:

assistant: SELECT "Name" FROM "Table" WHERE "Appointment" = 'October 24, 1997';