CREATE TABLE table_29716 ("Team" CLOB, "Outgoing manager" CLOB, "Manner of departure" CLOB, "Date of vacancy" CLOB, "Table" CLOB, "Incoming manager" CLOB, "Date of appointment" CLOB)

What is the date of appointment when the date of vacancy is 24 november 2010?
SELECT "Date of appointment" FROM table_29716 WHERE "Date of vacancy" = '24 November 2010'
SELECT "Date of appointment" FROM "table_29716" WHERE "Date of vacancy" = '24 November 2010'