rank nation gold silver bronze total
rank
nation
gold
silver
bronze
total
number
first second
number
number
number
number
number text(text) number number number number
1 united states (usa) 25 16 7 48
how many teams scored the same amount of gold medals as mexico ?
WRB JJ NNS VBD DT JJ NN IN NN NNS IN NNP .
8
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword
select count ( c2 ) from w where c2_first != 'mexico' and c3_number = ( select c3_number from w where c2_first = 'mexico' )
Keyword Keyword Column None None Keyword Keyword Keyword Column None Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2_first ['comp', 'comp_not'] ['comp', 'comp_not'] ['comp', 'comp_not'] c3_number ['comp', 'comp_not']