year competition venue position event notes
year
competition
venue
position
event
notes
number
address
number
first second first_number first_hour first_min first_sec
number text address rank text time(text)
1987 european junior championships birmingham, united kingdom 4th 20 km walk 1:18:59 (or)
what was the name of the competition that took place before the olympic games in 1996 ?
WP VBD-AUX DT NN IN DT NN WDT VBD NN IN DT NNP NNPS 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 = 'olympic games' and c1_number = 1996 ) order by c1_number desc limit 1
None None None None None None Column None Column Column Column None Literal Literal Column Literal None
c2 c1_number c1_number c1_number c1_number