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

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