Table: third_div_mngr_changes
Columns: team
outgoing_manager
manner_of_departure
date_of_vacancy
replaced_by
date_of_appointment

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

Question: I want the replaced for date of appointment being 12 october 2007
SQL: SELECT "replaced_by" FROM third_div_mngr_changes WHERE "date_of_appointment" = '12 october 2007'

Question: I want the team for date of vacancy being 28 february
SQL: SELECT "team" FROM third_div_mngr_changes WHERE "date_of_vacancy" = '28 february'

Question: I want the manner of departure for date of appointment being 12 october 2007
SQL: SELECT "manner_of_departure" FROM third_div_mngr_changes WHERE "date_of_appointment" = '12 october 2007'