team outgoing manager manner of departure date of vacancy replaced by date of appointment position in table
team
outgoing manager
manner of departure
date of vacancy
replaced by
date of appointment
position in table
first second
number parsed year month day
number parsed year month day
number
text text text(text) date text date rank
crystal palace peter taylor mutual consent (hired by bolton wanderers) 8 october 2007 neil warnock 11 october 2007 19th
what is the least number of days between vacancy and appointment dates ?
WP VBD-AUX DT JJS NN IN NNS IN NN CC NN NNS .
0 days
Keyword Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword
select min ( julianday ( c6_parsed ) - julianday ( c4_parsed ) ) from w
None None Keyword Keyword Keyword None Keyword Keyword Column Keyword Column None None
['max', 'max_min'] ['max', 'max_min'] ['before', 'before_minus'] ['', ''] ['before', 'before_minus'] c4_parsed ['before', 'before_minus'] c6_parsed