CREATE TABLE table_204_193 (id NUMBER, "year" NUMBER, "artist" CLOB, "album" CLOB, "chart position" CLOB, "role" CLOB)

who is the artist listed before ben e. king ?
SELECT "artist" FROM table_204_193 WHERE id = (SELECT id FROM table_204_193 WHERE "artist" = 'ben e. king') - 1
SELECT "artist" FROM "table_204_193" WHERE "id" = (SELECT "id" FROM "table_204_193" WHERE "artist" = 'ben e. king') - 1