CREATE TABLE table_204_239 (id NUMBER, "year" NUMBER, "title" CLOB, "uk" CLOB, "us:\ billboard\ hot 100" CLOB, "us:\ billboard\ r&b" CLOB, "us:\ billboard\ a/c" CLOB, "australia" CLOB, "various" CLOB)

what title was released previous to got ta be the one ?
SELECT "title" FROM table_204_239 WHERE id = (SELECT id FROM table_204_239 WHERE "title" = '"gotta be the one"') - 1
SELECT "title" FROM "table_204_239" WHERE "id" = (SELECT "id" FROM "table_204_239" WHERE "title" = '"gotta be the one"') - 1