I want the replaced for date of appointment being 12 october 2007
CREATE TABLE table_56404 (
    "Team" text,
    "Outgoing manager" text,
    "Manner of departure" text,
    "Date of vacancy" text,
    "Replaced by" text,
    "Date of appointment" text
)
SELECT "Replaced by" FROM table_56404 WHERE "Date of appointment" = '12 october 2007'
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: I want the replaced for date of appointment being 12 october 2007 ### Input: CREATE TABLE table_56404 (
    "Team" text,
    "Outgoing manager" text,
    "Manner of departure" text,
    "Date of vacancy" text,
    "Replaced by" text,
    "Date of appointment" text
) ### Response: SELECT "Replaced by" FROM table_56404 WHERE "Date of appointment" = '12 october 2007'