user: ### NOW ANSWER:
Question: I wan the date of vacancy for departure of Resigned and outgoing manager of Gordon Wylde
Columns: ['Team', 'Outgoing manager', 'Manner of departure', 'Date of vacancy', 'Replaced by', 'Date of appointment']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Stenhousemuir', 'Campbell Money', 'Resigned', '29 September 2007', 'John Coughlin', '12 October 2007']
SQL:

assistant: SELECT "Date of vacancy" FROM "Table" WHERE "Manner of departure" = 'Resigned' AND "Outgoing manager" = 'Gordon Wylde';