rank nation gold silver bronze total
rank
nation
gold
silver
bronze
total
number
number
number
number
number
number text number number number number
1 netherlands 20 9 0 29
nation that earned the most total medals after spain
NN WDT VBD DT RBS JJ NNS IN NNP
Belgium
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword
select c2 from w where c6_number < ( select c6_number from w where c2 = 'spain' ) order by c6_number desc limit 1
Column None None Keyword Keyword Column None Keyword Literal
c2 ['sort', 'sort_desc'] ['sort', 'sort_desc'] c6_number ['comp', '']