CREATE TABLE ship (name VARCHAR2, TYPE VARCHAR2, flag VARCHAR2, built_year VARCHAR2)

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