CREATE TABLE table_204_100 (id NUMBER, "date" CLOB, "name of ship" CLOB, "nationality" CLOB, "tonnage" NUMBER, "fate" CLOB)

what ship is recorded as sunk before the ss eros ?
SELECT "name of ship" FROM table_204_100 WHERE id = (SELECT id FROM table_204_100 WHERE "name of ship" = 'ss eros') - 1
SELECT "name of ship" FROM "table_204_100" WHERE "id" = (SELECT "id" FROM "table_204_100" WHERE "name of ship" = 'ss eros') - 1