Who was appointed on October 24, 1997?
CREATE TABLE table_76340 (
    "Name" text,
    "Background" text,
    "Title" text,
    "Appointment" text,
    "Presentation of Credentials" text
)
SELECT "Name" FROM table_76340 WHERE "Appointment" = 'october 24, 1997'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Who was appointed on October 24, 1997? ### Input: CREATE TABLE table_76340 (
    "Name" text,
    "Background" text,
    "Title" text,
    "Appointment" text,
    "Presentation of Credentials" text
) ### Response: SELECT "Name" FROM table_76340 WHERE "Appointment" = 'october 24, 1997'