stage date route terrain length winner
stage
date
route
terrain
length
winner
number
number parsed year month day
list length
first second first_number second_number
first second
number date <d, text> text unitnum(unitnum) text(text)
1 1 july saint-brieuc individual time trial 7.3 km (4.5 mi) jacky durand (fra)
how many routes have below 100 km total ?
WRB JJ NNS VBD-AUX IN CD NN NN .
4
select count ( c3 ) from w where c5_first_number < 100