rank team names time qualification
rank
team
names
time
qualification
number
list length
number min sec
number text <n,text> time text
1 france christophe capelle
philippe ermenault
jean-michel monin
francis moreau 4:09.570 q
how many teams finished better than spain in cycling at the 1996 summer olympics men 's team pursuit ?
WRB JJ NNS VBD JJR IN NNP IN NNP IN DT CD NN NNPS NNP POS NN NN .
6
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword
select count ( c2 ) from w where c1_number < ( select c1_number from w where c2 = 'spain' )
Keyword Keyword Column Column Column Column Literal None None None None None None None None None None None None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c1_number c1_number c1_number