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

what is the last recorded ship sunk on august 25 ?
SELECT "name of ship" FROM table_204_100 WHERE "date" = 8 AND "date" = 25 ORDER BY id DESC LIMIT 1
SELECT "name of ship" FROM "table_204_100" WHERE "date" = 25 AND "date" = 8 ORDER BY "id" DESC FETCH FIRST 1 ROWS ONLY