What is the most recent build year?
select max(built_year) from ship
Which ships were built in the most recent year?
select name from ship where built_year in (select max(built_year) from ship)
Also give the type and flag.
select name, type, flag from ship where built_year in (select max(built_year) from ship)