record athlete nation venue date #
record
athlete
nation
venue
date
#
first second first_number second_number
address
number parsed year month day
number
unitnum(unitnum) text text address date number
4.05 m (13 ft 31⁄4 in) sun caiyun china nanjing, china 21 may 1992 1
how many nations have set the record more than the united states ?
WRB JJ NNS VBD-AUX VBN DT NN RBR IN DT NNP NNPS .
2
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword
select count ( * ) from ( select c3 from w group by c3 having count ( * ) > ( select count ( * ) from w where c3 = 'united states' ) )
Keyword Keyword Column None None None None Keyword Keyword None Literal Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c3 ['comp', 'comp_greater'] ['comp', 'comp_greater']