rank name nationality time (hand) notes
rank
name
nationality
time -lrb- hand -rrb-
notes
number
number hour min sec
number text text time text
1 tommy green great britain 4:50:10 or
how many athletes were faster than bill chisholm ?
WRB JJ NNS VBD-AUX JJR IN NN NNP .
8
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 c4 < ( select c4 from w where c2 = 'bill chisholm' )
Keyword Keyword Column None Column Column Literal Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c4 c4