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
select c2 from w where id = ( select id from w where c2 = 'mexico' ) - 1