CREATE TABLE table_48831 ("Rank" FLOAT, "Location" CLOB, "2008" FLOAT, "2009" FLOAT, "2010" FLOAT, "2011" FLOAT, "2012" FLOAT)

Which 2012 has a 2011 of 17,142,000, and a 2010 smaller than 16,972,000?
SELECT MIN("2012") FROM table_48831 WHERE "2011" = '17,142,000' AND "2010" < '16,972,000'
SELECT MIN("2012") FROM "table_48831" WHERE "2010" < '16,972,000' AND "2011" = '17,142,000'