CREATE TABLE table_56406 ("Team" CLOB, "Outgoing manager" CLOB, "Manner of departure" CLOB, "Date of vacancy" CLOB, "Replaced by" CLOB, "Date of appointment" CLOB)

I want the manner of departure for date of appointment being 12 october 2007
SELECT "Manner of departure" FROM table_56406 WHERE "Date of appointment" = '12 october 2007'
SELECT "Manner of departure" FROM "table_56406" WHERE "Date of appointment" = '12 october 2007'