Table: mining_production
Columns: rank_2011
country
production_in_2011_1_000_ton
share_2011
rank_2010
production_in_2010_1_000_ton

Question: When indonesia is the country what is the rank of  2010?
SQL: SELECT "rank_2010" FROM mining_production WHERE "country" = 'Indonesia'

Question: When 5 is the rank of 2011 what is the country?
SQL: SELECT "country" FROM mining_production WHERE "rank_2011" = 5

Question: When sweden is the country what is the highest production in 2010 (1,000 ton)?
SQL: SELECT MAX("production_in_2010_1_000_ton") FROM mining_production WHERE "country" = 'Sweden'

Question: When 75849 is the production in 2010 (1,000 ton) what is the production in 2011 (1,000 ton)?
SQL: SELECT "production_in_2011_1_000_ton" FROM mining_production WHERE "production_in_2010_1_000_ton" = 75849