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
which competitor from united states had the longest time ?
WDT NN IN NNP NNPS VBD-AUX DT JJS NN .
Bill Chisholm
Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Column Keyword Keyword Keyword
select c2 from w where c3 = 'united states' order by c4 desc limit 1
None Column Column Literal Literal None Keyword Keyword Column None
c2 c3 ['sort', 'sort_desc'] ['sort', 'sort_desc'] c4