rank nation gold silver bronze total
rank
nation
gold
silver
bronze
total
first second
number
number
number
number
text text(text) number number number number
1 great britain (gbr) 2 1 2 5
how many countries won at least 1 gold and 1 silver medal ?
WRB JJ NNS VBD IN JJS CD NN CC CD NN NN .
5
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c3_number >= 1 and c4_number >= 1
Keyword Keyword Column None Keyword Keyword Literal Column None Literal Column None None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 ['comp', 'comp_gequal'] ['comp', 'comp_gequal'] c3_number c4_number