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
number parsed year month day
number parsed year month day
first second first_number second_number
text text text date text date rank(rank)
manchester city stuart pearce contract terminated 14 may 2007 sven-goran eriksson 6 july 2007 pre-season
how many teams had a manner of departure due to there contract being terminated ?
WRB JJ NNS VBD-AUX DT NN IN NN JJ TO EX NN VBG VBN .
5
select count ( c1 ) from w where c3 = 'contract terminated'