CREATE TABLE table_204_568 (id NUMBER, "pennant" CLOB, "name" CLOB, "hull builder" CLOB, "ordered" CLOB, "laid down" CLOB, "launched" CLOB, "accepted into service" CLOB, "commissioned" CLOB, "est. building cost" CLOB, "fate" CLOB)

what is the last listed pennant ?
SELECT "pennant" FROM table_204_568 ORDER BY id DESC LIMIT 1
SELECT "pennant" FROM "table_204_568" ORDER BY "id" DESC FETCH FIRST 1 ROWS ONLY