year competition venue position notes
year
competition
venue
position
notes
number
address
number
number text address rank text
1995 world indoor championships barcelona, spain 11th pentathlon
how many times did imma clopes compete before she came in 7th place ?
WRB JJ NNS VBD-AUX NNP NNP VB IN PRP VBD IN JJ NN .
3
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.Number Keyword
select count ( * ) from w where c1_number < ( select c1_number from w where c4_number = 7 )
Keyword Keyword Keyword None None None None Column None None None Literal Column None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c1_number c4_number