SELECT name ,  TYPE ,  flag FROM ship ORDER BY built_year DESC LIMIT 1
SELECT name ,  TYPE ,  flag FROM ship ORDER BY built_year DESC LIMIT 1 <table_name> : Ship col : Ship_ID | Name | Type | Built_Year | Class | Flag row 1 : 1 | HMS Manxman | Panamax | 1997 | KR | Panama row 2 : 2 | HMS Gorgon | Panamax | 1998 | KR | Panama row 3 : 3 | HM Cutter Avenger | Panamax | 1997 | KR | Panama row 4 : 4 | HM Schooner Hotspur | Panamax | 1998 | KR | Panama row 5 : 5 | HMS Destiny | Panamax | 1998 | KR | Panama row 6 : 6 | HMS Trojan | Panamax | 1997 | KR | Panama row 7 : 7 | HM Sloop Sparrow | Panamax | 1997 | KR | Panama row 8 : 8 | HMS Phalarope | Panamax | 1997 | KR | Panama row 9 : 9 | HMS Undine | Panamax | 1998 | GL | Malta
col : Name | Type | Flag row 1 : HMS Gorgon | Panamax | Panama