CREATE TABLE table_name_40 (date_of_appointment VARCHAR2, date_of_vacancy VARCHAR2)

What is the appointment day for 4 December 2008 vacancy?
SELECT date_of_appointment FROM table_name_40 WHERE date_of_vacancy = "4 december 2008"
SELECT "date_of_appointment" FROM "table_name_40" WHERE "4 december 2008" = "date_of_vacancy"