CREATE TABLE table_203_193 (id NUMBER, "ship name" CLOB, "in service" NUMBER, "project number" CLOB, "type" CLOB, "class" CLOB, "comments" CLOB)

which was the last ship in service ?
SELECT "ship name" FROM table_203_193 ORDER BY "in service" DESC LIMIT 1
SELECT "ship name" FROM "table_203_193" ORDER BY "in service" DESC FETCH FIRST 1 ROWS ONLY