CREATE TABLE table_204_646 (id NUMBER, "location" CLOB, "region" CLOB, "coordinates\ ( links to map & photo sources ) " CLOB, "population" NUMBER, "elevation" NUMBER)

after lima , which location has the next highest population ?
SELECT "location" FROM table_204_646 WHERE "population" < (SELECT "population" FROM table_204_646 WHERE "location" = 'lima') ORDER BY "population" DESC LIMIT 1
SELECT "location" FROM "table_204_646" WHERE "population" < (SELECT "population" FROM "table_204_646" WHERE "location" = 'lima') ORDER BY "population" DESC FETCH FIRST 1 ROWS ONLY