rank nation gold silver bronze total
rank
nation
gold
silver
bronze
total
number
number
number
number
number
number text number number number number
1 brazil 13 18 12 43
nation to earn the most gold medals after colombia
NN TO VB DT RBS JJ NNS IN NNP
Venezuela
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 c3_number < ( select c3_number from w where c2 = 'colombia' ) order by c3_number desc limit 1
Column None None Keyword Keyword Column None Keyword Literal
c2 ['sort', 'sort_desc'] ['sort', 'sort_desc'] c3_number ['comp', '']