CREATE TABLE table_name_2 (manner_of_departure VARCHAR2, date_of_appointment VARCHAR2)

I want the manner of departure for 1 june 2007
SELECT manner_of_departure FROM table_name_2 WHERE date_of_appointment = "1 june 2007"
SELECT "manner_of_departure" FROM "table_name_2" WHERE "1 june 2007" = "date_of_appointment"