numbers
tops numbers
tops numbers
pre-tops name(s) dates final livery operator withdrawn status
numbers tops
numbers tops
numbers pre tops
name -lrb- s -rrb-
dates
final livery
operator
withdrawn
status
number
number
list length
list length list_minimum_number list_minimum_parsed list_minimum_year list_maximum_number list_maximum_parsed list_maximum_year
number parsed year month
first second second_number second_parsed second_year second_month
number number text <n, text> <n, timespan> text text date text(date)
86101 86201 e3191 sir william a stanier frs 1978-2005
2006- british rail blue ac locomotive group 04/2002 scrapped at mod caerwent (04/2005)
what is the number of trains that are still in service ?
WP VBD-AUX DT NN IN NNS WDT VBD-AUX RB IN NN .
16
select count ( c4 ) from w where c9 = 'in service'