user: Question: In football league one, what coach was hired as a replacement on 8 October 2007
Columns: ['Team', 'Outgoing manager', 'Manner of departure', 'Date of vacancy', 'Replaced by', 'Date of appointment', 'Position in table']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Carlisle United', 'Neil McDonald', 'Contract terminated', '13 August 2007', 'John Ward', '2 October 2007', '8th']
SQL:

assistant: SELECT "Replaced by" FROM "Table" WHERE "Date of vacancy" = '8 October 2007';