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

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