CREATE TABLE table_204_332 (id DECIMAL, "administrative\ area" TEXT, "area\ km2" DECIMAL, "area\ sq mi" DECIMAL, "population" DECIMAL, "administrative\ centre" TEXT)

what administrative area comes before nightingale island ?
SELECT "administrative\narea" FROM table_204_332 WHERE id = (SELECT id FROM table_204_332 WHERE "administrative\narea" = 'nightingale island') - 1
SELECT "administrative\narea" FROM "table_204_332" WHERE "id" = (SELECT "id" FROM "table_204_332" WHERE "administrative\narea" = 'nightingale island') - 1