In football league one, what coach was hired as a replacement on 8 October 2007
CREATE TABLE table_28181347_6 (replaced_by VARCHAR, date_of_vacancy VARCHAR)
SELECT replaced_by FROM table_28181347_6 WHERE date_of_vacancy = "8 October 2007"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28181347_6 (replaced_by VARCHAR, date_of_vacancy VARCHAR) Question: In football league one, what coach was hired as a replacement on 8 October 2007 [/INST] SELECT replaced_by FROM table_28181347_6 WHERE date_of_vacancy = "8 October 2007" </s>