CREATE TABLE ship (ship_id NUMBER, name CLOB, type CLOB, built_year NUMBER, class CLOB, flag CLOB)
CREATE TABLE captain (captain_id NUMBER, name CLOB, ship_id NUMBER, age CLOB, class CLOB, rank CLOB)

Find the name, type, and flag of the ship that is built in the most recent year.
SELECT name, type, flag FROM ship ORDER BY built_year DESC LIMIT 1
SELECT "name", "type", "flag" FROM "ship" ORDER BY "built_year" DESC FETCH FIRST 1 ROWS ONLY