CREATE TABLE table_204_100 (id DECIMAL, "date" TEXT, "name of ship" TEXT, "nationality" TEXT, "tonnage" DECIMAL, "fate" TEXT)

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 NULLS LAST LIMIT 1