rank nation gold silver bronze total
rank
nation
gold
silver
bronze
total
number
number
number
number
number
number text number number number number
1 cuba 9 11 12 32
the nation before mexico in the table
DT NN IN NNP IN DT NN
Puerto Rico
Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword
select c2 from w where id = ( select id from w where c2 = 'mexico' ) - 1
None Column Keyword Literal Keyword Keyword Keyword
c2 ['before', 'before_minus'] ['before', 'before_minus'] ['before', 'before_minus'] ['before', 'before_minus']