-- Database schema
| captain : Captain_ID [ INT ] primary_key , Name [ TEXT ] , Ship_ID [ INT ] captain.Ship_ID = Ship.Ship_ID , age [ TEXT ] , Class [ TEXT ] , Rank [ TEXT ] | Ship : Ship_ID [ INT ] primary_key , Name [ TEXT ] , Type [ TEXT ] , Built_Year [ INT ] , Class [ TEXT ] , Flag [ TEXT ] |
-- -- What is the name, type, and flag of the ship that was built in the most recent year?

SELECT name ,  TYPE ,  flag FROM ship ORDER BY built_year DESC LIMIT 1;