rank nation gold silver bronze total
rank
nation
gold
silver
bronze
total
number
number
number
number
number
number text number number number number
1 nigeria 14 12 9 35
the team before algeria
DT NN IN NNP
Nigeria
select c2 from w where id = ( select id from w where c2 = 'algeria' ) - 1