rank nation gold silver bronze total
rank
nation
gold
silver
bronze
total
number
number
number
number
number
number text number number number number
1 japan 5 2 0 7
which country got at least one of each medal ?
WDT NN VBD IN JJS CD IN DT NN .
China
Keyword Column Keyword Keyword Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number
select c2 from w where c3_number >= 1 and c4_number >= 1 and c5_number >= 1
None Column None Keyword Keyword Literal None Column Column None
c2 ['comp', 'comp_gequal'] ['comp', 'comp_gequal'] c5_number c5_number