year competition venue position notes
year
competition
venue
position
notes
number
address
first second first_number
number
number text address rank(text) unitnum
2003 world youth championships sherbrooke, canada 10th (q) 1.75 m
in how many competitions has irina gordeeva finished higher than 10th but lower than fourth ?
IN WRB JJ NNS VBD-AUX NNP NNP VBD JJR IN JJ CC JJR IN JJ .
5
select count ( c2 ) from w where c4_first_number < 10 and c4_first_number > 4