rank name nationality time notes
rank
name
nationality
time
notes
number
number min sec
number text text time text
1 dyana calub australia 1:01.77 q
how many swimmers were there from the united states in the top five in the semifinals ?
WRB JJ NNS VBD-AUX EX IN DT NNP NNPS IN DT JJ CD IN DT NNS .
3
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c3 = 'united states' and c1_number <= 5
Keyword Keyword Column None None Column None Literal Literal None Column Column Literal None None None None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c3 c1_number c1_number