year competition venue position notes
year
competition
venue
position
notes
number
address
first second first_number
first second first_number second_result
number text address rank(text) unitnum(score)
1996 world junior championships sydney, australia 15th (q) 7.91 m (w)
which competition did this person compete in immediately before the east asian games in 2001 ?
WDT NN VBD-AUX DT NN VB IN RB IN DT JJ JJ NNS IN CD .
World Championships
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.Number Keyword Keyword Keyword Column Keyword Keyword Keyword
select c2 from w where c1_number < ( select c1_number from w where c2 = 'east asian games' and c1_number = 2001 ) order by c1_number desc limit 1
None Column None None None None None Column Column None Literal Literal Literal Column Literal None
c2 c1_number c1_number c1_number