Table schema:
CREATE TABLE table_name_22 (date_of_vacancy VARCHAR, manner_of_departure VARCHAR, outgoing_manager VARCHAR)

Question: I wan the date of vacancy for departure of resigned and outgoing manager of gordon wylde
SQL: SELECT date_of_vacancy FROM table_name_22 WHERE manner_of_departure = "resigned" AND outgoing_manager = "gordon wylde"